My Oracle Support Banner

OBIEE 12.2.1.4 Admin tool - fail to create ODBC Systems Datasource (Doc ID 2495989.1)

Last updated on AUGUST 14, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

OBIEE 12.2.1.4.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 12.2.1.4.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)"

 

 

 

Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.