ClassNotFoundException Connecting to Server
Brought to you by:
brill
Menu
▾
▴
I don't know if there's anyone out there. This forum appears to be pretty unused. But I'll give it a shot anyway.
I just installed v1.1.3 for Windows. I imported a the MSSQL driver jar, and then setup a server. However when I attempt to connect to the server I get the following error:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
How can this be? I can see the class for myself inside the driver jar, mssqlserver.jar.
Any help will be apreciated.
Thanks, Albert
Hi Albert,<BR>
You might get that error for a few resons, but the most likley is the jar is not a "standard" java Jar, or is using MS specific classes, which would not work with Sun's JDK.
<P>
What I suggest is the following to ensure you have everything correct:
<LI> Make a copy of the JAR file, and rename it to .zip, you can then view the contents; you want to make sure you driver class is there, and not in some sub path. it will look something like "com.microsoft.sqlserver.DriverName though I don't know the exact package. Basically you want to make sure the JAR you installed is not a distribution package, but a driver library.
<LI> Make sure you have the name of the driver correct in the server connection dialog
<LI> Make sure there are no class references that are microsoft specific... the ClassNotFoundException might tell you what class was missing.
<P>
I have sucessfully connected to an SQL Server using the ODBC drivers from Sun... though its not idea if you have native JDBC drivers, that is another possibility.
<P>
If you still have trouble, then let me know, I'll get you to export you connections and send me your driver library so I can recreate your working conditions.
Were you able to use the MS driver? I am having the same problem. I'll see if I can find Sun's ODBC.
Ah JDK seems to have this one in it by default: sun.jdbc.odbc.JdbcOdbcDriver
Now I just have to figure how to get the database connected!