| 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: 8876
|
|
|
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.
|
|
 |
|
|
subject: JDBC-ODBC
|
|
|
0
