File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC with SQL server 2000" Watch "JDBC with SQL server 2000" New topic

JDBC with SQL server 2000

kanchi kaul

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

Joined: Jan 10, 2002
Posts: 63854

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.

JavaRanch Sheriff

[Asking smart questions] [About Bear] [Books by Bear]
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
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.
I agree. Here's the link:
subject: JDBC with SQL server 2000
It's not a secret anymore!