Hi...

    I am facing problem while connecting to SQL Server 2000 through Java Program... It showing the following problem...


 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.


Code given below...


package DataBase;

import java.sql.*;
/**
 *
 * @ Author :- Nigamananda Rout
 * @ E-mail :- [email protected]
 *
 * @ Changed on February 8, 2007, 3:34 PM
 */
public class SqlServer_Test {

    /** Creates a new instance of SqlServer_Test */
    public SqlServer_Test() {
    }

 public static void main(String ns[])
 {

        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLSer verDriver");

            String db_connect_string = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Nigam";
            String db_userid = "sa";
            String db_password = "passwd" ;

            Connection conn = DriverManager.getConnection(db_connect_string, db_userid, db_password);
            System.out.println("connected");

        } catch (Exception e) {
            System.out.println("Not connected Due to Error " + e.toString());
      }
 }


Thank you...