Oracle Data Source Tests OK in TOAD/SQLPLUS - Error in Cognos Connection

[cognos_guru]

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.

[tupac_rd]

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

[sir_jeroen]

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?

[cognos_guru]

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.