[Wrapper-user] JDBC:ODBC Problem - Console = :) & Service = :(

[Ted H. <odi...@ho...>]

My application runs off two datasources.  One datasource uses a pure jdbc
driver (to get to MySQL) and the other uses the jdbc:odbc bridge to reach
Access.

When I run the application as a Console as in

--> Wrapper Started as Console

everything runs super fine.

When I run the application as a Service as in

--> Wrapper Started as Service

the pure jdbc datasource performs properly but the odbc datasource bombs :(

I get (from wrapper.log only when running the application as a service):

>java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]
>The Microsoft Jet database engine cannot open the file '(unknown)'.
>It is already opened exclusively by another user, or you need permission to
view its data.
>
>at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
>at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
>at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074)
>at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
>at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
>at java.sql.DriverManager.getConnection(DriverManager.java:512)
>at java.sql.DriverManager.getConnection(DriverManager.java:171)

etc.

The mdb (Access) datasource is set up without any username / password
required.

Why does everything work fine when run as a Console but not as a Service?

I read the other ODBC thread from 8/2004 but that didn't seem to shine much
light on my problem.  The ODBC datasource is set up as "System DSN".  I am
having this problem on NT4 as well as on Win2k.

Any help would be really appreciated.  Thanks.