Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java and MS SQL Server 2000

 
Hanna Habashy
Ranch Hand
Posts: 532
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
James Swan
Ranch Hand
Posts: 403
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
- 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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic