This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC 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 Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
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: 60072

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] [Bear's FrontMan] [About Bear] [Books by Bear]
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 39575
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.

Ping & DNS - updated with new look and Ping home screen widget
I agree. Here's the link:
subject: JDBC with SQL server 2000
Similar Threads
JDBC with Session Beans
using datasource - connection pooling
Need JDBC Program for SQL server 2000
Connecting to MS SQL Server 2000 Personal Edition
connection pooling in websphere 5.1