My Oracle Support Banner

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

Last updated on MARCH 18, 2021

Applies to:

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


OBIEE 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 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

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