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 Different versions of SQL Server 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 "Different versions of SQL Server" Watch "Different versions of SQL Server" New topic

Different versions of SQL Server

Antonio Giovanni
Ranch Hand

Joined: Jun 27, 2005
Posts: 85

well i do not understand the order of different versions of MS SQL server.

You have SQL server 7.0, 8.0 like .. and you have SQL Server 2000, 2005 like.. Does anybody have any idea on the order of these versions?? Is 8.0 before 2000?? I am curious.

I am trying to access Sql Server, through JDBC driver, provided by MS and i get this exception, when i try to connect

I am not exactly sure on the version of the SQL server i am accessing, probably 8.0.
I have to talk to the admin

Antonio Giovanni
Ranch Hand

Joined: Jun 27, 2005
Posts: 85

The above link gave some great help, I am actually accessing SQL Server 7.0 SP4.

It would be great if anybody can help me find a JDBC driver for SQL server 7.0.

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33119

I haven't tried it, but there is an open source driver called jTDS for SQL Server including version 7.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Different versions of SQL Server
It's not a secret anymore!