This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 8904

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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: JDBC-ODBC
 
Similar Threads
java.sql.Date problem
jdbc odbc driver download
ODBC and JDBC!!!
JDBC or ODBC and Excel
what is JDBC???