Problems with MSSQLServer and Java
I'm running SQLServer 2000 on XP on a new box. I've copied old code to the new box. Running the code to test the SQL connect I get the message.
The box is on a home network, with a wireless router. I access the internet without problems.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
I went back to the old machine Win2k and ran the same code against MSSQLServer 2000 with no errors.
Other things I did:
I runing Norton Security 2005 on both machines.
pinged localhost on the XP no problem
ping the ComputerName and got timed out
Shut down Norton and repeated the ComputerName ping no problems
ran the java code and got the same error message.
Ran the SQL update SP4 and retested the above with the same results.
I'm not too clear on how one should turn on/off ports.
I tested the SQL connect using the ODBC Manager no problems there.
Any one have any ideas?