RE: [Wrapper-user] JdbcOdbc bridge problem

[Earnie D. <ed...@vr...>]

This is probably a permissions issue. Access has to be able to create a
"lock" file in the same directory as the "mdb" file. Are you running
your service under a user account or localsystem? I would think you
would be better served by using a real user account rather than
localsystem.

Earnie!

-----Original Message-----
From: wra...@li...
[mailto:wra...@li...]On Behalf Of Stan Pinte
Sent: Thursday, August 19, 2004 12:43 PM
To: wra...@li...; Eric Baelen
Subject: [Wrapper-user] JdbcOdbc bridge problem


hello,

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

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

It says:

INFO   | jvm 1    | 2004/08/19 18:40:15 | Caused by:=20
java.sql.SQLException: Gene
ral error
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at=20
sun.jdbc.odbc.JdbcOdbc.create
SQLException(JdbcOdbc.java:6987)
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at=20
sun.jdbc.odbc.JdbcOdbc.standa
rdError(JdbcOdbc.java:7115)
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at=20
sun.jdbc.odbc.JdbcOdbc.SQLDri
verConnect(JdbcOdbc.java:3074)
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at=20
sun.jdbc.odbc.JdbcOdbcConnect
ion.initialize(JdbcOdbcConnection.java:323)
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at=20
sun.jdbc.odbc.JdbcOdbcDriver.
connect(JdbcOdbcDriver.java:174)
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at=20
java.sql.DriverManager.getCon
nection(DriverManager.java:512)
INFO   | jvm 1    | 2004/08/19 18:40:15 |       at=20
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=3DC:/Program Files/j2sdk_nb/j2sdk1.4.2/bin/=20
(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=3Dstan
wrapper.ntservice.account=3DXXXXX

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

thanks a lot for insights...

Stan.




-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
Wrapper-user mailing list
Wra...@li...
https://lists.sourceforge.net/lists/listinfo/wrapper-user