"MSSQL driver not available" when connecting to MSSQL 2008 from DAC 10.1.3.4.1 on Unix / Linux
Last updated on MARCH 08, 2017
Applies to:Data Warehouse Business Adapter for PeopleSoft - Version: 220.127.116.11 [AA 1830]
Information in this document applies to any platform.
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.
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