1. Are the ODBC Data Sources User or System? (If user, then only
the user that created them can see them)
2. The JDBC-ODBC bridge loads a dll in order to communicate. Is
this DLL available to the service?
Also, you should be aware that the JDBC-ODBC bridge is not thread
safe. If you attempt concurrent access, the process will crash and cause
the JVM you are accessing it from to have an Illegal Error.
Randy
-----Original Message-----
From: Peter Nguyen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 12:07 AM
To: [EMAIL PROTECTED]
Subject: Tomcat service using JDBC-ODBC bridge
I am running Tomcat on Windows 2000 with jdk1.2.2. I have servlets accessing
an
MS Access and Oracle database. The servlets work fine with Sun's JDBC-ODBC
bridge against MS Acces and Oracle's thin driver against the Oracle
database.
When I set Tomcat up as a NT service Oracle worked fine after I put the
Oracle
drivers on the classpath in wrapper.properties.
However, I started to have problems when I tried to get the MS Access
connection. The driver registered fine but attempting to get a connection
resulted in:
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
Note that the exact same configuration worked fine when running Tomcat as a
normal app and not as a service. Does Sun's JDBC-ODBC bridge rely on
something
else that is not accessible when run as a service? Or did I miss something
else?
Cheers,
Peter
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]