This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
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 SQL server 2000

 
kanchi kaul
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there,
I am confused about the databse connectivity with Java using SQl server 2000.Do i need Seperate Driver for that? SQl server driver is already there in windows XP by default.So should i need extra for live project.
and what would be the connection String for sql server 2000.
Thank you,
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64629
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to the Ranch, kanchi kaul.

Please take the time to choose the correct forum in which to make your posts. We have a forum for JDBC posts. This one is for questions regarding JSP.

I have moved this post to the appropriate forum for you.

bear
JavaRanch Sheriff
 
Ulf Dittmer
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I doubt that the SQLServer JDBC driver is part of standard Windows. Microsoft has a driver for SQLServer 200, but it's reportedly buggy. The freeware driver jTDS is much to be preferred. Links to both can be found in the GeneralJdbcQuestions FAQ page.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic