Discussion Locked

MS SQL SERVER and JAVA JDBC

0 helpful
10 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does anyone know how to connect to the database in the MS SQL SERVER 6.0 or 7.0 using JAVA's jdbc ?
can anyone provide details of how to do it ? or where i can get it ?thank you.
I will be using java to as an interface to access the database in the MS SQL SERVER.

10 replies

by vikrant.goswami

You can also use the JDBC-ODBC bridge to connect to any database(as long as it supports ODBC), except that it would be comparatively slower than the native drivers.

by amanabala

I am assuming that you have used JDBC earlier. Connecting to MS SQL Server using JDBC is just like connecting to Oracle or any other database, except for a few parameters that are different.

Given the fact that SQL Server is from Microsoft, we have no native jdbc driver for SQL Server from Microsoft, like Oracle's driver. This leads us to the following possibilities:

1. Use the generic JDBC-ODBC driver from java
2. Use a third party native driver or type 3 driver. Merant has one native driver, I remember a native driver that came with Weblogic Server 5 but I am not sure if it is comercially available.

I will be glad to give you more information, if you need any.

Good luck!
Ravi

by rob

Check out http://www.jnetdirect.com/JSQLFeatures.htm

JSQLConnect is a native (Type 4 - Written in 100% Java and talks directly to MS TDS protocol to MS SQL 6.5, 7.0, 200) They support a lot of nice features, like pooling for instance) They have a30-day free trial. Because it's a type 4, I use it on both linux and windows. You won't have to do any complicated installation: just drop their jar in you classpath and go. Also, I would expect that merant has a type 4. MS has recently made a deal with merant: They will make JDBC drivers available to their SQL Server customers, but I don't know the details.

by billp

You may want to take a look at http://www.inetsoftware.de/

They have a full range of type 4 JDBC drivers for MS SQL and others. I have been using them since 1998 in 24x7 operations and have had great success. They are fast, reliable and priced very reasonably.

This discussion is closed to new replies.