Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Driver for SQL server

 
Cindy Jones
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 257
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why don't you get the Java Drivers(type4) from the Microsoft website?
 
Paul Clapham
Sheriff
Posts: 21581
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic