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!