"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 FEBRUARY 14, 2019
Applies to:Data Warehouse Business Adapter for PeopleSoft - Version 220.127.116.11 [AA 1830] and later
Information in this document applies to any platform.
On: Oracle BI Applications 18.104.22.168
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)
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document