Originally posted by Rich Morrison:
Semi-newbie problem.
Environment:
Windows XP workstation,
WSAD 5.1.1
MS Access 2000 database
I am trying to connect to a Microsoft Access 2000 data base using the jdbcodbc bridge. I get a runtime SQLException "No suitable driver" from the statement
conn = DriverManager.getConnection(Url);
Yes, the Url is well formed.
Yes, the class sun.jdbc.odbc.JdbcOdbcDriver is loaded.
[QB I believe the appropriate jars are in the classpath; rt.jar and j2ee.jar .
The Jar that is rewuired here in the calsspath is that of the Driver. Make sure that you have the Driver available to Websphere.
--Basu
This happens in a WebSphere "Web" project.
The same code works in a WebSphere "Java" project using Swing controls instead of jsp pages.
I have tried to configure the test server on my workstation by adding rt.jar and j2ee.jar as "External JARS" for the default server configuration. That does not help.
Any suggestion will be appreciated.
Thanks,
Rich Morrison