Created On:  13 October 2011

Problem:

When verifying the connection properties in the "StarTeam Database" tab in the Datamart Extractor the following error results:

Resolution:

There are two possible causes of this issue:

- The target SQL Server is version 2000 or older.
- The JDBC driver in use by Datamart is version 1.1 or older.

Solution 1

Upgrade the target SQL Server to SQL Server 2000 or later.

Solution 2

1.  Log an incident with supportline and request version 1.2 of the MS JDBC drivers.
2.  Extract the archive to disk on the machine on which Datamart is installed.
3.  Open the file "StarTeamDatamart.stjava"
4.  Locate the line beginning with "CLASSPATH= "
5.  Edit the path to the JDBC driver to refer to the sqljdbc.jar file in the folder extracted as above. i.e.

classpath=stxtract.jar;C:\Program Files\Microsoft SQL Server 2008 JDBC Driver\sqljdbc_1.1\enu\sqljdbc.jar;...

6.  Relaunch Datamart and verify the database connection.
Incident #2540684