Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC-ODBC

 
sennat ms
Greenhorn
Posts: 4
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there any other way to connect to an SQL database other than JDBC-ODBC.
If so please tell me how to do it. sennat_ms@yahoo.co.in
 
Pradeep bhatt
Ranch Hand
Posts: 8927
Firefox Browser Java Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MS SQL ? Yes you can use jTDS driver.
 
Dave Salter
Ranch Hand
Posts: 293
Java Mac OS X Netbeans IDE
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you're using SQL Server, theres also the new Microsoft drivers which are supposedly greatly improved.

If you are running in a production environment, I wouldn't recommend using the JDBC-ODBC driver - I'd always use a type 4 driver if possible.
 
Pankaj Shirke
Greenhorn
Posts: 4
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
You can use jTDS JDBC driver which is an open source or you also have an option of downloading a type 4 driver from Microsoft's Site for MS-SQL Server from this URL given below.It is only for SQL Server 2000 so if you are using it you can go gor ithttp://www.microsoft.com/downloads/details.aspx?FamilyID=4F8F2F01-1ED7-4C4D-8F7B-3D47969E66AE&displaylang=en

( You have not specified the version of sql server you are using)

Also there is also a jdbc driver aveConnect 3.1 available for MS-SQL versions 6.5,7.0,SQL Server 2000 but it is not free of cost.It is available on 30 days trial basis.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic