[Wrapper-user] JdbcOdbc bridge problem

[Stan P. <sta...@ax...>]

hello,

I have a web application connecting to an access database using Sun's 
JdbcOdbc bridge...

It works well when I run the wrapper from the command-line...but not 
when started as a service.

It says:

INFO   | jvm 1    | 2004/08/19 18:40:15 | Caused by: 
java.sql.SQLException: Gene
ral error
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at 
sun.jdbc.odbc.JdbcOdbc.create
SQLException(JdbcOdbc.java:6987)
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at 
sun.jdbc.odbc.JdbcOdbc.standa
rdError(JdbcOdbc.java:7115)
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at 
sun.jdbc.odbc.JdbcOdbc.SQLDri
verConnect(JdbcOdbc.java:3074)
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at 
sun.jdbc.odbc.JdbcOdbcConnect
ion.initialize(JdbcOdbcConnection.java:323)
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at 
sun.jdbc.odbc.JdbcOdbcDriver.
connect(JdbcOdbcDriver.java:174)
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at 
java.sql.DriverManager.getCon
nection(DriverManager.java:512)
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at 
java.sql.DriverManager.getCon
nection(DriverManager.java:140)

--> any idea what I could try out?

I have tried the following:

1: adding this

wrapper.java.library.path.2=C:/Program Files/j2sdk_nb/j2sdk1.4.2/bin/ 
(so that JdbcOdbc.dll and related dlls are in the path)

2: running the service under another account like this:

# runs under another account...
wrapper.ntservice.account=stan
wrapper.ntservice.account=XXXXX

3: copying JdbcOdbc.dll in JBOSS_HOME/lib directory, where we find 
wrapper.dll

thanks a lot for insights...

Stan.