JDBC with MS SQL 2000

[Rohan Kalbhor]

Hello,
I have tried connecting my java program with ms sql 2000 server,I have completed all necessary prerequisites

1.Downloaded n installed driver
2.gave class path of driver
3.saw configuration of my sql server

  
package sql2000test;
import java.sql.*;
import com.microsoft.jdbc.sqlserver.*;
/**
 *
 * @author Rohan
 */
public class Main {
 
   
    public Main() 
    {
        try {  
 
          
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();  
            System.out.println("Found driver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.1.19:1433;User=sa;Password=sa");
          
            System.out.println("Done with connection");
 
 
        } catch (Exception e) {  
            System.err.println("Got an exception! ");  
            System.err.println(e.getMessage());  
        }  
    }

My command line after i run the code

 Found driver
Got an exception! 
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
BUILD SUCCESSFUL (total time: 1 second)
   

[Ulf Dittmer]

Is the SQLServer at that IP address set up to accept TCP/IP connections on that port?

[Rob Spoor]

Is the database really a SQL Server 2000, and not SQL Server 2005?

I've had some problems connecting to SQL Server 2005 with SQL Server 2000 drivers which threw the exact same error.

Can you omit the port? It will then use the default port.

[Rohan Kalbhor]

Is the SQLServer at that IP address set up to accept TCP/IP connections on that port?

Hi Ulf,

It is done, the problem exists

[Rohan Kalbhor]

Hi Rob,

I tried that too. No joy mate.