Hey there - trying to get FM 8.4 FP2 working on my new workstation: Windows 7 Enterprise 64bit with Oracle client 11g 32bit. When I'm testing data source connections on any existing models that working just fine anywhere else (WinXP or directly on Cognos Win2k3 server) I'm getting the same error:
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
UDA-SQL-0031 Unable to access the "<DB_NAME>" database.
UDA-SQL-0107 A general exception has occurred during the operation "attach".
Yes, I added all necessary Environment Variable (ORA_HOME, TNS_ADMIN)
Yes, I tested data sources from Cognos connection.
Yes, I copied ojdbc14.jar to the Cognos local directory (maybe there is new JAR file I need for 11g?)
Yes, Oracle tools (SQL Plus, PL/SQL Developer) working just fine on my workstation.
Cognos support mumbling already a week to try to get something for me, but so far... nothing valuable.
Can someone please get me any suggestion here?