File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 29220
    
135

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Different versions of SQL Server
 
Similar Threads
JDBC-ODBC
Getting ClassCastExceptions with CachedRowSet
HELP please with SQL Server
Need to know Sql version.
Connection Pooling Error