Menu
▾
▴
Re: [Wrapper-user] JdbcOdbc bridge problem
|
From: Stan P. <sta...@ax...> - 2004-08-20 07:04:13
|
Leif Mortenson wrote: > Stan, > How did you declare your ODBC data source in the ODBC control panel? > Was it > declared system-wide? Or just for the current user? As stated, when > running as a service, > the Wrapper and its JVM will be run as the System user. If the data > source is not declared > to be system wide then it will not be available. The DSN was a system DSN. I checked it, and saw that I had a User DSN with the same name...--> I deleted this USer DSN. I doesn't work better. Since you can't set > the user, try that. > I am pretty sure this is not a library or class path issue as you are > using the sun ODBC > JDBC driver. Unfortunately, that exception message is not very > informative. :-/ > "General error". Someone should be shot. indeed. ;-) thanks for the help!! Maybe the culprit is just windows XP home edition... > > Cheers, > Leif > > Stan Pinte wrote: > >> 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 > |
