× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




Hi Gary,

Call me foolish, but after initially trying the jTDS, and after some starting mis-steps by M$, I went to the Microsoft JDBC Driver for SQL Server:

http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx

I don't recall any specific complaints about jTDS. I think set up was a little different and there may not have been support for some things I needed at the time. So, this is not a "my dog's better than yours," but I haven't had any complaints so far, and it actually runs in the standard way.

I may sing a different tune in a few weeks as I have an upcoming client migration in which older versions of Glassfish, the JVM and JDBC drivers will be replaced with current versions on new hardware. I'll chime in if I encounter issues.

As to SQuirreL "runs very slowly" check any logs and driver set up. Also logs on the SQL Server side. As noted, I haven't used the jTDS driver in some time, so google is your friend. Offhand, it sounds like the driver keeps trying to connect, sort of like a loop.

BTW, while cross posting to multiple forums seems like a good idea, if people notice, you often won't get answers on either one.

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: Thursday, November 21, 2013 2:18 PM
To: Java Programming on and around the IBM i
Cc: Midrange Systems Technical Discussion
Subject: problems attempting adding jTDS driver to Squirrel

I am following Dan Kimmel's suggestion to use the JTDS open-source-driver
for connections to MS Sequel Server.

I think I got a good download of jTDS from Sourceforge

I think my extract was Ok, and I see a bunch of files and folders
with same "Date Time mod" on my Win 7 laptop:

Files
CHANGELOG, jtds-1.3.1.jar, LICENSE, README, README.SSL
README.SSO, README.XA

Folders
x64
x86

Squirrel now runs very slowly and I can't select an
SQL statement to run ??
the cursor, in Squirrel, seems un-responsive and will
not allow a click on "run", etc

Have not yet been able to close Squirrel . . .





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.