Re: [Wrapper-user] JdbcOdbc bridge problem

[Leif M. <le...@ta...>]

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.   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.

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.
>