|
From: Jeansonne, J. <joe...@nm...> - 2012-05-15 11:26:56
|
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? Have a great day! Joe Jeansonne From: Matt Dahlman [mailto:mda...@ja...] Sent: Monday, May 14, 2012 8:03 PM To: Jeansonne, Joey Cc: squ...@li... Subject: Re: [Squirrel-sql-users] Problem loading jTDS driver for MS SQL 2000 Joe, 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. Regards, Matthew Dahlman Jaspersoft 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? Have a great day! Joe Jeansonne ------------------------------------------------------------------------ ------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________ ________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
