Test adapter connection failed!

i’m using VS 2005 and MS SQL server 2000, DB-VA SQL

I connect
Driver : MS SQL Server
Adapter file : <<jTDS 1.2>>
Hostname : 127.0.0.1
Database name : HRManagement
UserName : sa
Password

but i can’t connect
ERROR :
Test adapter connection failed!
java.sql.SQLException: Network error IOException: Connection refused:
connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:372)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at org.orm.ertodb.DriverWrapper.connect(DriverWrapper.java:27)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at v.ihmp.i(:34)
at v.ihmp.f(:43)
at v.awo.run(:21)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:289)
at net.sourceforge.jtds.jdbc.SharedSocket.(SharedSocket.java:250)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:297)
… 8 more

Hi leminhviet,

Please make sure the TCP/IP protocol is enabled and all the information you entered is correct.

Best regards,
Jick