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 Java and MS 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 "Java and MS SQL Server 2000" Watch "Java and MS SQL Server 2000" New topic

Java and MS SQL Server 2000

Hanna Habashy
Ranch Hand

Joined: Aug 20, 2003
Posts: 532
I have never accessed a database from my Java application before. Now, I am learning MS SQL server 2000. How can I access the data stored in SQL server throw my Java application?

SCJD 1.4<br />SCJP 1.4<br />-----------------------------------<br />"With regard to excellence, it is not enough to know, but we must try to have and use it.<br />" Aristotle
James Swan
Ranch Hand

Joined: Jun 26, 2001
Posts: 403
- you need to download some JDBC drivers for SQL Server 2000
- run the setup.exe program which installs the drivers
the setup program installs 3 jars to the following location:
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\
- include these jars in your classpath
- try some code
- of course you need to fill in some blanks such as:
- servername
- db name
- user/password
- table details
I agree. Here's the link:
subject: Java and MS SQL Server 2000
It's not a secret anymore!