Connection refused

[zeero]

hi all, I installed a new jtds driver, set the classpath, and wrote a test program to go into a db and print out part of a table. anyways, here's my set up:

I have a linux server running apache tomcat and I'm connecting to a windows server 2000 machine with ms sql 2000 and getting the following error:

org.apache.jasper.JasperException: Network error IOException: Connection refused

could this be an internal error as in somehting wrong with the linux machine or would it be a permission thing on the ms sql 2000 on the windows machine? As far as I know, everything seems to be setup correctly, just not sure why I can't connect. here's my connection setup code btw:

Class.forName("net.sourceforge.jtds.jdbc.Driver");
String url = "jdbc:jtds:sqlserver://<IP>:<port>/petdata";
Connection con = DriverManager.getConnection(url,"<user>","<pass>");
Statement stmt = con.createStatement();

the "<>" are replacements not actually in the code

 

[sedj]

Can you telnet to the db port ? I expect it is a network/firewall issue.

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[zeero]

I was just messing around with the code and this seemed to work:

String url = "jdbc:jtds:sqlserver://<IP>/<db>;INSTANCE=<myinstance>";

*assuming default port

 

[prosper]

just wonder if you use jtds-0.9.jar?

http://sourceforge.net/project/showfiles.php?group_id=33291

 

[zeero]

yes, 0.9.jar