SQL Server based incident and defect tracking software
Bugzero one-for-all defect and incident tracking software
Q: Can the Microsoft SQL Server 2000 JDBC driver be used on SQL Server 7?

A: The SQL Server 2000 JDBC driver downloaded from Microsoft supports only the
   SQL Server 2000. If you use it on the SQL Server 7, you will get something like:
   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 ask Microsoft for a driver that supports SQL Server 7.

   There are also 3rd party JDBC drivers for Microsoft SQL Servers. Some are free, such
   as the often recommended jTDS JDBC driver (http://jtds.sourceforge.net).

   Another option is to create a data source (DSN) that points to your SQL Server 7
   and then use the jdbc-odbc driver for the DSN.

   In either cases, before you launch the Bugzero setup program, you need modify the file
   db.properties. See comments inside the file.

   If you have a connection problem, see SQL Server JDBC Connection Errors

* Reference brought to you by Bugzero, it's more than just bug tracking software!

Home - FAQs