Hi.
I have installed C10.1.1(64bit) and enabled DQM and when I try to connect to data source in Cognos Connection ODS fails, JDBC succeedded
Oracle/Cpmpatible Failed (No message)
Oracle (JDBC) / Dynamic Succeeded
Is this Normal?
This is a single server instance. I have also trouble creating a power Cube and Package, In transformer it pops for Signon, signons are available and if I cancel I will get an error Logon Failed, Unable to connect to at least one database during a multi database attach to 1 databases in:
Is this related to the ODBC failure?
And in the model when I test for data few views give an error " table or View doesnot exist", But they are verymuch available
Thank you.
Did you install the 32-bit Oracle client on your server. The Compatible Query Mode uses this one.
Also, if you have enabled 64 bit report server execution mode, then you are limited to DQM data sources only. You need 32 bit report server execution mode enabled for any CQM connections. You can find this in Cognos Configuration - environment tab.
Cheers!
MF.