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?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL