jdbc sqlserver2000

import java.sql.*;
<br>import com.microsoft.jdbc.sqlserver.SQLServerDriver;
<br>
<br>public class test {
<br>
<br> public static void main(String[] args) {
<br>
<br>  String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";  
<br>  String dbURL = "jdbc:microsoft:sqlserver://127.0.0.1:1433; DatabaseName=pubs";  
<br>  String userName = "sa";  
<br>  String userPwd = "sa";  
<br>  Connection dbConn;
<br>  try {
<br>   
<br>   Class.forName(driverName);   
<br>   dbConn = DriverManager.getConnection(dbURL, userName, userPwd);  
<br>   System.out.println("Connection Successful!");
<br>   dbConn.close();
<br>  }
<br>  catch (Exception e) {
<br>   e.printStackTrace();  
<br>  }
<br> }
<br>
<br>}

-------------