I have not used the jTDS driver.
But if the driver definition needs the class com.microsoft.sqlserver.jdbc.SQLServerDriver, and your .jar file does not include this, then it won't work.
That class looks like it's part of the Microsoft SQL Server JDBC driver delivered by Microsoft rather than the jTDS driver. You could download Microsoft's JDBC driver. Perhaps that's what you're missing.
On 15 May 2012, at 4:26, Jeansonne, Joey wrote:
OK, so I put the drivers in a separate folder. Updated the driver’s “extra class path” to include the folder. When I click “ok” I get… ‘Could not find class com.microsoft.sqlserver.jdbc.SQLServerDriver in neither the Java class path nor the Extra class path of the jTDS Microsoft SQL driver definition: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver’. Do I need to include any more files? From: Matt Dahlman [mailto:email@example.com]
Sent: Monday, May 14, 2012 8:03 PM
To: Jeansonne, Joey
Subject: Re: [Squirrel-sql-users] Problem loading jTDS driver for MS SQL 2000
Don't put the JDBC driver in squirrel\lib.
You CAN do that, and it will work to some extent as you noticed. But instead you should put your JDBC drivers somewhere else. For example, I put mine in a directory called "JDBC" under my home directory.
Then for any unloaded driver (a driver with the red "x" next to it) bring up its properties. Go to the tab "Extra Class Path" and add in the relevant .jar file(s). That way you explicitly set the .jars to be used by that driver.
Good luck. Let us know if that solves it.
On 11 May 2012, at 12:21, Jeansonne, Joey wrote:
Hey guys, I was wondering if anyone else has run into the problem I have. I have downloaded the JAVA SQK, squirrel, and jTDS. I have installed JAVA and squirrel. I start up squirrel and look at the drivers list and jTDS Microsoft SQL, jTDS, and jTDS Sybase all have red “X” symbols next to them. I then dropped the “jtds-1.2.5.jar” into the “C:\Program Files\squirrel-sql-3.3.0\lib” and restart squirrel. The jTDS Sybase driver now has a blue check mark beside it. The jTDS and jTDS Microsoft SQL drivers still have the red “x” next to them. I have searched the web and can’t find any answers. Could someone please help?