RE: problems attempting adding jTDS driver to Squirrel

Joe Sam,
copied from my Squirrel session:
Change Driver: jTDS Microsoft SQL
Class Name: net.sourceforge.jtds.jdbc.Driver
Extra Class Path: C:\jarFiles\jtds-1.3.1.jar
I am missing something ?
But, project demands attention so I
must attack this at a later date - Thank You!

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Sam Shirah
Sent: Friday, November 22, 2013 8:46 AM
To: Java Programming on and around the IBM i
Subject: Re: problems attempting adding jTDS driver to Squirrel


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.

--
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.

--
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.