aspose file tools*
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
Author

JDBC-ODBC

sennat ms
Greenhorn

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. sennat_ms@yahoo.co.in
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

MS SQL ? Yes you can use jTDS driver.


Groovy
Dave Salter
Ranch Hand

Joined: Jul 20, 2005
Posts: 292

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

Joined: Sep 28, 2005
Posts: 4
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.
 
Don't get me started about those stupid light bulbs.
 
subject: JDBC-ODBC