File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with MSSQL SPRINTA 2000 JDBC Driver

 
Dallas Cowboy
Greenhorn
Posts: 4
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 149
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 64178
83
IntelliJ IDE Java jQuery Mac Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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
 
Craig Schwabl
Greenhorn
Posts: 7
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic