Re: Problem while trying to connect to mySql server via JDBC...
Posted by: Oliver James
Date: December 15, 2004 11:20AM

Problem solved! I was defining CLASSPATH on the Windows command line, but it had double quotes around the path to the JDBC installation. When I removed the quotes, all was fine. Transcript below :-

C:\j2sdk1.4.0\files>set classpath
classpath="C:\J2SDK1.4.0\MYSQL_JDBC";.

C:\j2sdk1.4.0\files>java LoadDriver
Error loading driver
Message: com.mysql.jdbc.Driver
Cause: null
Error establishing connection
SQLException: No suitable driver
SQLState: 08001
VendorError: 0

C:\j2sdk1.4.0\files>set classpath=C:\J2SDK1.4.0\MYSQL_JDBC;.

C:\j2sdk1.4.0\files>java LoadDriver

C:\j2sdk1.4.0\files>

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.