This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
What is "Connection Pooling"
Application Hang when delete() method execute
No suitable driver error
Best JDBC drivers?
Scrollable ResultSet