Hi, I have installed MQ SQL Server 2000 on my laptop and trying to use SPRINTA 2000 JDBC Driver (inetmssql.jar) to connect to the local db. I wrote a sample Java app to test the connection and I get the following error trace,
DriverManager.initialize: jdbc.drivers = null JDBC DriverManager initialized SQLException: SQLState(08S01) {sql7=true, port=1433, user=sa, url=jdbc:inetdae7:US0-WP01:1433, password=passMe, host=US0-WP01} getConnection failed: com.inet.tds.SQLException: Connection refused: connect com.inet.tds.SQLException: Connection refused: connect 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.Socket.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at java.net.Socket.<init>(Unknown Source) at java.net.Socket.<init>(Unknown Source) at com.inet.tds.TdsDriver.a(Unknown Source) at com.inet.tds.TdsDriver.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
I tried searching the web and product doc. Nothing seems to help me. Has anyone come across similiar problems? Any pointers will be appreciated also.
We're pleased to have you here with us on the Ranch, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
"Connection refused" means that the database server actively refused the connections, which usually means that nothing is listening on the specified port. Are you sure that your SQL server is listening on port 1433? If so, are you positive that it is up and running?
0
