Meaningless Drivel is fun!*
The moose likes JDBC 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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Different versions of SQL Server" Watch "Different versions of SQL Server" New topic
Author

Different versions of SQL Server

Antonio Giovanni
Ranch Hand

Joined: Jun 27, 2005
Posts: 85
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



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
Ranch Hand

Joined: Jun 27, 2005
Posts: 85
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30138
    
150

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


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Different versions of SQL Server
 
Similar Threads
Connection Pooling Error
JDBC-ODBC
Getting ClassCastExceptions with CachedRowSet
Need to know Sql version.
HELP please with SQL Server