OCI.DLL error connecting to Oracle DB in Impromptu 7.5

oracle11g business-intelligence cognos impromptu
Jimsan picture Jimsan · Dec 5, 2012 · Viewed 7.2k times · Source

I am trying to connect to an Oracle 11 database in Impromptu 7.5 but I am getting the below error. This is generated when trying to open a catalogue and when the option for 'connect to database' is selected:

Error number -45: 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

I am using Impromptu version 7.5 on a Windows 7 64 bit machine attempting to connect to an Oracle 11g database. I have the Oracle 11g client installed on my machine and the correct service name configured for my database in Net8 Assistant.

I have also checked the C:\oracle\product\11.2.0\client_1\BIN directory and OCI.DLL exists there. This directory is also referenced in my PATH variable.

I am able to connect to the database without issue using Aqua Data Studio v12 but it just seems to be Impromptu 7.5 that doesn't like it.

Any ideas anyone? Could it just be a compatibility issue? Thanks

Answer

Related questions

OBIEE Answers not showing results

I recently installed OBIEE 11.1.1.6.0. I imported the repository I had from 11.1.1.5 which was working fine till now. In the administration tool, I can query my data and update the rows, I can connect with the same credentials as the connection …

Read More
How to change the date format in Oracle BI Publisher?

How do I change the format of the date while creating a report using data model which I created using a simple SQL query which fetches aggregated data from a data warehouse? I need the date in a simple dd-mon-yy …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More