I solved the problem right after sending the email. I had set my ODBC source in
User rather than System. Works fine now.
Peter
> -----Original Message-----
> From: Randy Layman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 22 February 2001 11:28 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Tomcat service using JDBC-ODBC bridge
>
>
>
> 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
