File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases and the fly likes JDBC with SQL server 2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC with SQL server 2000" Watch "JDBC with SQL server 2000" New topic
Author

JDBC with SQL server 2000

kanchi kaul
Greenhorn

Joined: Dec 29, 2006
Posts: 1
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

Joined: Jan 10, 2002
Posts: 61968
    
  67

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


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Ulf Dittmer
Rancher

Joined: Mar 22, 2005
Posts: 42952
    
  73
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.
 
Don't get me started about those stupid light bulbs.
 
subject: JDBC with SQL server 2000