JDBC Driver problem

Swamipsn · #1 (**permalink**) 08-09-2007, 08: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 · #2 (**permalink**) 08-09-2007, 09:53 AM

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

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)

Code:

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

Swamipsn · #3 (**permalink**) 08-09-2007, 04:35 PM

No I dont want to use jdbc

dbc dridge. I want direct SQLServer driver

henry_78 · #4 (**permalink**) 08-09-2007, 04: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.