PRB: No Suitable Driver Exception With JDBC Bridge and SDK

• SDK for Java, versions 2.0, 2.01
• Microsoft Win32 Virtual Machine for Java

SYMPTOMS

When running your Java class that uses the JDBC bridge with the SDK for Java 2.0 or newer, you see the following exception:

   java.sql.SQLException: No suitable driver

CAUSE

One of the frequent causes for this exception is running any application that the JDBC bridge shipped with the SDK for Java 2.0 Beta.

RESOLUTION

In general, the package name has changed to com.ms.jdbc.odbc with Internet Explorer 4.0x and SDK for Java 2.0x Virtual Machines. For example the following lines should be changed:

   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

   -or-

  Class.forName("com.ms.sql.CDriver");

   Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");

MORE INFORMATION

Other common causes for "No suitable driver" are invalid connection strings, user IDs, passwords, and security restrictions imposed on the driver (if it was downloaded and is not trusted).

REFERENCES

More information on the JDBC driver is included the SDK 2.0x for Java documentation and the "JDBC" sample available with the SDK2.0x.

For the latest Knowledge Base articles and other support information on Visual J++ and the SDK for Java, see the following page on the Microsoft Technical Support site:

   http://support.microsoft.com/support/visualj/
   http://support.microsoft.com/support/java/

Keywords          : JDB
Technology        : kbInetDev internet odbc
Version           : WINDOWS:2.0,2.01
Platform          : WINDOWS
Issue type        : kbprb