JDBC Driver problem

**Swamipsn** · 08-09-2007, 07:38 AM

Hi,
I am using "com.microsoft.jdbc.sqlserver.SQLServerDriver" and "net.sourceforge.jtds.jdbc.Driver" for SQLServer 7.0 but both of the drivers are not support my JVM and throw class not found exception. So please anydody suggest some other drivers which are support SQLServer 7.0 for JDK1.5..

**vata2999** · 08-09-2007, 08:53 AM

You can use jdbc-odbc bridge but it is too slow java is not work with sql
well

Java Code:

 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Driver={MS 
SQL};server=.;database=northwind","sa","secret");

Or use DSN(Data source name)

Java Code:

DriverManager.getConnection("jdbc:odbc:dsnName");

**Swamipsn** · 08-09-2007, 03:35 PM

No I dont want to use jdbc:odbc dridge. I want direct SQLServer driver

**henry_78** · 08-09-2007, 03:55 PM

Hi,
Areu sure u have downoladed frominternet the jar file of the diver and included it in the path of the your application???
Make sure that u did, Bye.