Try using a system DSN instead of a user DSN.
Al R.
-----Original Message-----
From: Curi, Miguel E (Miguel) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 05, 1999 9:36 AM
To: [EMAIL PROTECTED]
Subject: Servlets and JDBC
I am working on a web base application that uses a servlet to access a
database using the JDBC-ODBC bridge (sun.jdbc.odbc.JdbcOdbcDriver). The
database is a MS Access database. I am having trouble connecting to the
database.
My program is able to load the driver but it fails to open the connection.
I am using :
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:MyDatabase"); <----
This fails.
I have MyDatabase setup in the ODBC Datasource Administrator of Windows NT
Workstation 4.0 SP4 as:
User DSN: Pointing to my database file
D:\JavaWebServer1.1.3\database\mydata.mdb with no passwords.
Anyone has any ideas????? It also happens with stand alone applications so
I'm thinking something is wrong in my ODBC settings in Windows.
Need Help!
---------------------------------------
Miguel Curi
Lucent Technologies
Network Wireless Systems
phone: (614) 860-3438
[EMAIL PROTECTED]
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff JSP-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff JSP-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
