Different versions of SQL Server

[Antonio Giovanni]

Hi,

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

 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]
This version of the JDBC driver only supports Microsoft SQL Server 2000.
You can either upgrade to SQL Server 2000 or possibly locate another
version of the driver. 

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

Thanks

[Antonio Giovanni]

http://www.sqlteam.com/item.asp?ItemID=8318

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.

Thanks

[Jeanne Boyarsky]

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