OBIEE 18.104.22.168 Admin tool - fail to create ODBC Systems Datasource
(Doc ID 2495989.1)
Last updated on JANUARY 30, 2020
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
OBIEE 126.96.36.199.0 server and Admin tool are installed on the same Microsoft Windows x64 (64-bit) 2012R2 machine.
Trying to configure a new ODBC Systems Datasource to resolve the error message in OBIEE 188.8.131.52.0 Admin tool when try to open an RPD in Online mode ("No ODBC Systems Datasource is defined for Oracle BI Server" ), following these steps:
On the client machine where Admin tool is installed, navigate to "Control Panel\All Control Panel Items\Administrative Tools".
Click on "Data Sources (ODBC)" to open it.
Navigate to the System DSN page, and click on "Add" button.
Select the Oracle BI Server-[ORACLE_HOME] as the driver name.
However, getting the following error:
"The setup routines for the Oracle BI Server ODBC driver could not be loaded due to system error code 1114: A dynamic link library (DLL) initialization routine failed. (OBIEE server <ORACLE HOME>\oracle_common\..\bi\bifoundation\server\bin\nqssetup.dll)"
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