Search code examples
javajdbcsql-server-7

JDBC driver for SQL Server 7.0?

I need to retrieve datas from the SQL Server 7.0 through java.

I have tried the following drivers

  • msbase.jar
  • mssqlserver.jar
  • msutil.jar
  • sqljdbc.jar
  • sqljdbc4.jar

These jars works fine for the SQL Server versions 2000 and above, but for the version 7.0 its displaying error like The TDS prelogin response is incomplete. The target server must be SQL Server 2000 or later.

What are the drivers I should use to retrieve datas from the Sql Server 7.0 through java?

Solution

  • The jtds driver should work fine.

    http://jtds.sourceforge.net/

    I have used it for MSSQL 2000, but the website claims it works for 7.0 as well.