Created On:  18 October 2011

Problem:

When attempting to verify the database connection settings in Datamart 2009 the following error results:

Resolution:

This issue can be resolved by referencing the JDBC 4.0 driver in the Datamart CLASSPATH:

1.  Close Datamart
2.  Browse to the Datamart installation directory
3.  Open "StarTeamDatamart.stjava" in a text editor
4.  Locate the line beginning with CLASSPATH=
5.  Edit this line to refer to sqldbc4.jar rather than sqljdbc.jar

classpath=stxtract.jar;C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\sqljdbc4.jar;C:\oracle\10g2\jdbc\lib\ojdbc14.jar;lib\ServerDDB.jar;lib\xercesImpl.jar

6.  Relaunch Datamart

The issue should now be resolved.
Incident #2540684