Re: [Wrapper-user] JdbcOdbc bridge problem

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

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
>