JDBC Driver with SQL Server 6.5?

[Jon]

Hi,

Will appreciate if anyone has any info about the JDBC
driver working with MS SQL Server 6.5.

Regards,

Jon

[Russ Gray [MS]]

We try to maintain backwards compatibility, so it should work as long as
you don't do anything that's SQL 2000 specific. However, you should be
aware that this is an untested and unsupported configuration.

Russ Gray
Microsoft Developer Support

This posting is provided “AS IS” with no warranties, and confers no rights.

[Joseph Weinstein]

Hi, It is my understanding that the next release of the free MS driver will
be explicitly, internally, limited to connecting to SQL2000 for non-technical
reasons. The current beta version doesn't connect at all to SQL7:

Exception in thread "main" java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]No more data a
vailable to read.
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)

This is because there was a significant change in the client-DBMS protocol
between SQL6.5 and SQL7, and the current free driver only speaks the latter.
There are commercial drivers available for SQL6.5.

Joe Weinstein at B.E.A.