Couldn't find JDBC drivers for Microsoft SQL Server in ./lib directory.

Document ID : KB000090265
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Couldn't find JDBC drivers for Microsoft SQL Server in ./lib directory.
Resolution:
Detailed Description and Symptoms

When you run Admin.bat using the latest SQL Server Driver (sqljdbc4.jar) the following error:

Couldn't find JDBC drivers for Microsoft SQL Server in ./lib directory


Investigation

The admin.bat doesn't include a entry for the latest SQL Server driver:

java -classpath clearview_admin.jar;lib\commons-logging-1.1.jar;lib\crypt.jar;lib\uc4.jar;lib\ojdbc5.jar;lib\ojdbc6.jar;lib\sqljdbc.jar;lib\sqljdbc4.jar;lib\db2jcc.jar;lib\db2jcc4.jar com.uc4.gwa.admin.Main -r -w
pause


Solution

?Add 'lib\sqljdbc4.jar' to the path and run the admin.bat again.