Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC with MS SQL 2000

 
Rohan Kalbhor
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ulf Dittmer
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is the SQLServer at that IP address set up to accept TCP/IP connections on that port?
 
Rob Spoor
Sheriff
Pie
Posts: 20495
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Rohan Kalbhor
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Rob,

I tried that too. No joy mate.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic