December 8, 2009 at 9:44 am
Hi,
I have a Java application which connects to sql server using JDBC. I have connected to mnay sql servers and the applciation has worked fine. However this one instance i have got the following error:
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
No only has it produced the above error, but it seems that it corrupts the ODBC datasource. So we roll back to a backed up version. I execute no query, just try and connect to the database. I have no idea and have googled all day... Any ideas?
regards
December 9, 2009 at 6:22 am
Can you connect using any other application? Can you check to make sure that the SQL Server allows remote connections? You can check that from SQL Server Surface Area Configuration Tool. By default SQL Server 2005 does not allow remote connections.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply