Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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 Android Security Essentials Live Lessons this week in the Android 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: 60810

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: 41155
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 - my free Android networking tools app
I agree. Here's the link:
subject: JDBC with SQL server 2000
Similar Threads
JDBC with Session Beans
using datasource - connection pooling
connection pooling in websphere 5.1
Need JDBC Program for SQL server 2000
Connecting to MS SQL Server 2000 Personal Edition