This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes JDBC with MS SQL  2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC with MS SQL  2000" Watch "JDBC with MS SQL  2000" New topic
Author

JDBC with MS SQL 2000

Rohan Kalbhor
Ranch Hand

Joined: Aug 18, 2006
Posts: 78
Hello,
I have tried connecting my java program with ms sql 2000 server,I have completed all necessary prerequisites

1.Downloaded n installed driver
2.gave class path of driver
3.saw configuration of my sql server



My command line after i run the code


..............................<br />Exceptions are a part of possibility<br />Errors are a part of truth<br />................................
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41592
    
  55
Is the SQLServer at that IP address set up to accept TCP/IP connections on that port?


Ping & DNS - my free Android networking tools app
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19674
    
  18

Is the database really a SQL Server 2000, and not SQL Server 2005?

I've had some problems connecting to SQL Server 2005 with SQL Server 2000 drivers which threw the exact same error.

Can you omit the port? It will then use the default port.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Rohan Kalbhor
Ranch Hand

Joined: Aug 18, 2006
Posts: 78
Is the SQLServer at that IP address set up to accept TCP/IP connections on that port?


Hi Ulf,

It is done, the problem exists
Rohan Kalbhor
Ranch Hand

Joined: Aug 18, 2006
Posts: 78
Hi Rob,

I tried that too. No joy mate.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC with MS SQL 2000