COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: lorenmario on 01 Aug 2014 02:26:53 PM

Title: Error creating connection ORACLE OCI, help me!
Post by: lorenmario on 01 Aug 2014 02:26:53 PM
Hello!

I'm having trouble creating a connection to Oracle.
The first step where I point the connection string, username and password is successfully tested.
Then when I click Next, I need to configure OCI, I've tried several ways, but does not work.
Error message appears:
XQE-GEN-0002 An unexpected exception ocurred: ocijdbc11 (c :/ program Files/ibm/cognos/c10_64/bin64 \ ocijdbc.dll is not a valid Win32 application.)

This dll does not exist in my environment, so I had to download and put at the above address, but not worked. I tried to download the 64-bit version of the dll, but it does not work.

I need to make this connection work for my template Framework is QCM and it does not work without this detail OCI.

I appreciate if someone can help me!
Title: Re: Error creating connection ORACLE OCI, help me!
Post by: MFGF on 02 Aug 2014 09:04:37 AM
Quote from: lorenmario on 01 Aug 2014 02:26:53 PM
Hello!

I'm having trouble creating a connection to Oracle.
The first step where I point the connection string, username and password is successfully tested.
Then when I click Next, I need to configure OCI, I've tried several ways, but does not work.
Error message appears:
XQE-GEN-0002 An unexpected exception ocurred: ocijdbc11 (c :/ program Files/ibm/cognos/c10_64/bin64 \ ocijdbc.dll is not a valid Win32 application.)

This dll does not exist in my environment, so I had to download and put at the above address, but not worked. I tried to download the 64-bit version of the dll, but it does not work.

I need to make this connection work for my template Framework is QCM and it does not work without this detail OCI.

I appreciate if someone can help me!

Hi,

Does this link help?

http://www-01.ibm.com/support/knowledgecenter/?lang=en#!/SSEP7J_10.2.0/com.ibm.swg.ba.cognos.ig_rolap.10.2.0.doc/t_ig_rolap_oracle_connect.html

Cheers!

MF.