All -
I am trying to set up a new data source connection within cognos connection. The db has been added to the tnsnames.ora file on the Cognos Server and the connection succeeds from SQLPLUS and TOAD. When I try to add the new connection in cognos connection, I get the following error:
QE-DEF-0285 Logon failure.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
testDataSourceConnection
Any ideas? The SID is exactly the same as defined in the tnsnames file.
try either of these...
http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bQE-DEF-0285&uid=swg21338701&loc=en_US&cs=utf-8&cc=us&lang=all
or
http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bQE-DEF-0285&uid=swg21371588&loc=en_US&cs=utf-8&cc=us&lang=all
What type of connection are you setting up? Are you using an ODBC instead of Oracle?
But most of all what version of Cognos 8 are you using and what version of Oracle Client?
I got it to work. It was an Oracle connection to Cognos 8.3.
The problem was that there were multiple copies of the TNSNAMES.ORA file on the server. Once I got rid of the extra copies it worked.