Hi Gary,
As mentioned in my previous mail, I'm not using the jTDS driver, but
type 4 setups are similar. Looking at the jTDS FAQ:
What are the class names of the Driver, DataSource,
ConnectionPoolDataSource, XADataSource and ObjectFactory implementations?
http://jtds.sourceforge.net/faq.html#driverImplementation
It shows:
net.sourceforge.jtds.jdbc.Driver
as the current driver class.
You *should* be able to add the location in Squirrel's "Extra Class
Path" box, then put the above in the "Class Name" drop down, and be pretty
much in business ( also see the example URL. )
The message you got below:
Could not find class com.internetcds.jdbc.tds.Driver...
clearly says the class name used could not be found.
HTH,
Joe Sam
Joe Sam Shirah - www.conceptgo.com (904) 302-6870
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum: www.ibm.com/developerworks/java
Just the JDBC FAQs: www.jguru.com/faq/JDBC Going International?
www.jguru.com/faq/I18N
Que Java400? www.jguru.com/faq/Java400
-----Original Message-----
From: Gary Thompson
Sent: Friday, November 22, 2013 10:12 AM
To: Java Programming on and around the IBM i
Subject: RE: problems attempting adding jTDS driver to Squirrel
D*B
Thank you.
0 java skills on my part.
Have been attempting what you suggest:
on Change Driver: jTDS:
Name: jTDS
Class Name: com.internetcds.jdbc.tds.Driver
Extra Class Path: C:\jarFiles\jtds-1.3.1.jar
Error in bottom pane of Squirrel:
Could not find class com.internetcds.jdbc.tds.Driver in neither the Java
class path nor the Extra class path of the jTDS driver definition:
java.lang.ClassNotFoundException: com.internetcds.jdbc.tds.Driver
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx]
On Behalf Of D*B
Sent: Friday, November 22, 2013 7:26 AM
To: java400-l@xxxxxxxxxxxx
Subject: RE: problems attempting adding jTDS driver to Squirrel
Gary,
open the Drivers panel (there are Drivers and Aliases), then choose jTDS
Microsoft SQL an go through the add Driver (+) process and tell Squirrel
where the jar is located.
D*B
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/java400-l.
midrange.com
