But I get the following error when I run the program. The error occurs on the DriverManager.getConnection line:
SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
I've searched the web extensively for a solution. Infact I put the port number '1433' after going through some forums. I have checked the port the SQL server is listening to and it is 1433. The error still persists.
Has anyone got a solution for this problem? I have already spent an entire day on this.