Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connecting to sql server

 
Sameera Abeysinghe
Ranch Hand
Posts: 104
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all
I am using jdk 1.5 with netbeans 4
I need to connect to sql server. I download the jdbc driver from
Sorry but I cant remember the path
But when I try to connect to the server it gives an error
Establishing socket or connection
Did I download the wrong driver? is there a specific driver for jdk 1.5
Any one give me an answer with the correct driver path to download
I am using sql server 2000 developers edition
And
I am using sql server 2000 personal edition

And tell me what this means
//////////////////////////////

Is the sqlserver listen on TCP/IP?

////////////////////////////////


Thank You.
 
David Ulicny
Ranch Hand
Posts: 724
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is the sqlserver listen on TCP/IP?


It means that you are trying to connect to the server through TCP/IP. You could configure your SQL server to use another connection type e.g. pipes etc. Maybe you are connecting to wrong port.
 
Pradyut Bhattacharya
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
are u using the port number 1433 in the url in the jdbc driver path in the program. thats the default port that sql server uses

also check that the sql server that u r connecting is listening to the port or the sql server is started or not
also check that please check that sql server agent and sql server distributed coordinater is started or not.

thanks
Pradyut
http://pradyut.tk
 
Nitin Jawarkar
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello Sameera

can you post the code which you aregiving error.ok

Thanx
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic