|
From: Ted H. <odi...@ho...> - 2005-03-25 22:58:39
|
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. |