File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JBoss/WildFly and the fly likes JDBC-ODBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "JDBC-ODBC" Watch "JDBC-ODBC" New topic


sennat ms

Joined: Feb 07, 2006
Posts: 4
Is there any other way to connect to an SQL database other than JDBC-ODBC.
If so please tell me how to do it.
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8927

MS SQL ? Yes you can use jTDS driver.

Dave Salter
Ranch Hand

Joined: Jul 20, 2005
Posts: 293

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

Joined: Sep 28, 2005
Posts: 4
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 it

( 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:
subject: JDBC-ODBC
jQuery in Action, 3rd edition