aspose file tools
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 Groovy Fundamentals video training course this week in the Groovy 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
Author

Java and MS SQL Server 2000

Hanna Habashy
Ranch Hand

Joined: Aug 20, 2003
Posts: 532
hi:
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
http://www.microsoft.com/downloads/details.aspx?FamilyID=86212d54-8488-481d-b46b-af29bb18e1e5&DisplayLang=en
- 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: http://aspose.com/file-tools
 
subject: Java and MS SQL Server 2000