|
From: Stan P. <sta...@ax...> - 2004-08-20 06:40:31
|
Earnie Dyke wrote: > 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 am using the LocalSystem...and I tried to chmod the directory in which access is running, with no luck... As I am running windows XP home edition, I cannot grant the "Logon as Service" right to the user... I'll try on another machine! thanks. 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 > 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. > > > > > ------------------------------------------------------- > 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 > > > ------------------------------------------------------- > 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 > |