How to connect Sql Server 2000 using JDBC ODBC Driver

How to connect Sql Server 2000 using JDBC ODBC Driver ?plz Send Syntax.thanks

[98 byte] By [NikisinProblema] at [2007-11-27 7:46:55]

# 1

In SQL Server 2000 the driver class is com.microsoft.jdbc.sqlserver.SQLServerDriver

The connection URL for the default SQL Server 2000 database is jdbc:sqlserver://localhost:1433

Class.forName(

"com.microsoft.sqlserver.jdbc.

SQLServerDriver");

String url =

"jdbc:sqlserver://localhost:1433";

Connection conn = DriverManager.

getConnection(

url, "sa", "sqlserver");

dvohra09a at 2007-7-12 19:27:55 >

# 2

For SQL Server 2000Class.forName( "com.microsoft.jdbc.sqlserver. SQLServerDriver");

dvohra09a at 2007-7-12 19:27:55 >

# 3

well, it's not jdbc-odbc driver... =)

j_shadinataa at 2007-7-12 19:27:55 >

Database Connectivity Hot Topic