IBM Support

DMS-E-CONNECTREJECT: Unable to connect to Oracle database

Troubleshooting


Problem

A new install of Impromptu Administrator 7.5 on Windows 7 64-bit operating system is unable to successfully connect to Oracle database using native database client or ODBC drivers. Errors encountered: Error number -4: DMS-E-CONNECTREJECT, A connection has been rejected by the remote interface during operation 'attach database'. ORA-12154: TNS:could not resolve service name DMS-E-DBDLL_NOTFOUND, The dynamic link library 'OCI.DLL' could not be located in the search path or one of its dependent dynamic link libraries failed to load.

Symptom

Issue only being encountered on a Windows 64-bit workstation. Same version of Impromptu and Oracle client on Windows 7 32-bit does not encounter the issues.

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu Web Reports","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.5","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
09 May 2025

UID

swg21660711

Page Feedback