aspose file tools*
The moose likes JDBC and the fly likes Problem with MSSQL SPRINTA 2000 JDBC Driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem with MSSQL SPRINTA 2000 JDBC Driver " Watch "Problem with MSSQL SPRINTA 2000 JDBC Driver " New topic
Author

Problem with MSSQL SPRINTA 2000 JDBC Driver

Dallas Cowboy
Greenhorn

Joined: May 22, 2002
Posts: 4
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.

Thanks,
Swami.
arnel nicolas
Ranch Hand

Joined: Dec 16, 2003
Posts: 149
Why not use the JDBC driver that comes from Micro$oft in fact its their DB that you are using.It should complement. Try downloading it here.




arnel




With great power comes great responsibility.
[ July 12, 2004: Message edited by: arnel nicolas ]
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61413
    
  67

"Dallas Cowboy",

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.

Thanks!
bear
Forum Bartender


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Craig Schwabl
Greenhorn

Joined: Nov 20, 2001
Posts: 7
"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?


Craig Schwabl<br />SCJP2<br />SCWCD<br />SCBCD<br />IBM Certified Specialist (WSAD 4.0.3)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem with MSSQL SPRINTA 2000 JDBC Driver