"MSSQL driver not available" when connecting to MSSQL 2008 from DAC 10.1.3.4.1 on Unix / Linux (Doc ID 1316426.1)

Last updated on MARCH 08, 2017

Applies to:

Data Warehouse Business Adapter for PeopleSoft - Version: 7.9.6.2 [AA 1830] and later   [Release: V7 and later ]
Information in this document applies to any platform.

Symptoms

On: Oracle BI Applications 7.9.6.2
With: DAC Server 10.1.3.4.1 on RHEL 5 x86-64

DAC was configured to connect to a MS SQL Server 2008 source database as per the following Technical Note:
"MSSQL driver not available" when connecting to MSSQL 2008 from DAC 10.1.3.4.x (Doc ID 988634.1)

For example:
1.  The DAC Cumulative Patch (dated September 2010) was downloaded and applied to the DAC Client (on the MS Windows platform) and the DAC Server (on the RHEL platform).
2.  The latest MS SQL Server JDBC Driver (sqljdbc4.jar) was downloaded for and and installed on both the MS Windows and Unix platforms (sqljdbc4.jar was copied to the $ORACLE_HOME\bifoundation\dac\lib\ directory).
3.  The DAC configuration script was modified for both the MS Windows (config.bat) and Unix (config.sh) platforms such that the SQLSERVERLIB variable only included the .\lib\sqljdbc4.jar entry.
4.  The DAC Client and DAC Server were cycled.

In DAC > Setup > Physical Data Sources, a new record was created to connect to a MS SQL Server 2008 data source, and the following was observed:
1.  The "Test Connection" succeeds when connecting locally from the DAC Client on Windows (that is, the DAC Server is down when testing from the DAC Client).
2.  The "Test Connection" fails when connecting from the DAC Server on Unix (that is, the DAC Server is up when testing from the DAC Client) and the "MSSQL Driver not available!" error is thrown.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms