permaculture playing cards
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

Win a copy of Building Microservices this week in the Design forum!
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Java and MS SQL Server 2000
It's not a secret anymore!