• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Connecting to sql server

 
Ranch Hand
Posts: 104
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 724
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hello Sameera

can you post the code which you aregiving error.ok

Thanx
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic