aspose file tools
The moose likes JDBC and the fly likes Driver for SQL server Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Driver for SQL server" Watch "Driver for SQL server" New topic
Author

Driver for SQL server

Cindy Jones
Ranch Hand

Joined: Oct 08, 2002
Posts: 66
What is the best driver to use for SQL server?

My requirement is to have a type 4 open source driver. I am using jtds - is this a good choice?

Thanks!
Amit M Tank
Ranch Hand

Joined: Mar 28, 2004
Posts: 257
Why don't you get the Java Drivers(type4) from the Microsoft website?


Amit Tank
Linked In
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 16479
    
    2

The Microsoft driver worked fine for me until it had a problem with the SSL implementation on my iSeries. Then I switched to the JTDS driver which is also working fine for me.

Why do you need an open-source driver? Do you expect you will need to look at the source code to debug problems?
Cindy Jones
Ranch Hand

Joined: Oct 08, 2002
Posts: 66
I meant open source as being free. I was able to get it working with jtds and I wanted to confirm that it is dependable for production.

I will also check out the Microsoft drivers.

Thanks for your responses.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Driver for SQL server
 
Similar Threads
CachedRowSet
New JDBC driver in VAJ 4
Merant Driver for WAS 4.0x AE
Free JDBC driver for SQLServer 7?
Using a Datasource to connect to database