I installed MS SQL Server 5 Express. Downloaded sqljdbc.jar and added it to classpath. Trying to connect to a table with 5 rows as a test. When I run the program it is generating the following error: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect". I, then, tried by replacing localhost with IP address 126.96.36.199. Got the same error message. Any idea what mistake I'm making?
Between my first post on this matter and now I checked some internet resources and enabled the TCP/IP using configuration manager. I restarted SQL server and re-ran the program. Still getting the same error
Joined: Nov 02, 2008
Friends! I got it. Port in the SQL Server is different. I corrected port number in my code and connection succeeded. Thanks