COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: EArumugam on 08 Oct 2009 07:55:26 AM

Title: Datasource Connection Failed
Post by: EArumugam on 08 Oct 2009 07:55:26 AM
Hi All,

I am getting the below error when testing the datasource connection from Framework manager.

Pleae clarify , Its Urgent.

Tnsnames.ora file also updated accordingly.

QE-DEF-0285 The logon failed.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
G.0

UDA-SQL-0031 Unable to access the "G.0" database.
UDA-SQL-0532 Data Source is not accessible: "G.0".
ORA-12154: TNS:could not resolve the connect identifier specified

Thanks in advance.
Title: Re: Datasource Connection Failed
Post by: angela on 12 Oct 2009 02:27:59 PM
Did you get this resolved?  My first thought is that it looks like there's a period in the DNS name and I'm not sure that's allowed.  My second thought is - are you CREATING the data source in FM?  In the past whenever I tried that it failed, but if I created it in Cognos Connection first it worked just fine in FM.
Title: Re: Datasource Connection Failed
Post by: DustPanMan on 10 Dec 2009 09:16:58 AM
I am having this exact same issue with an Oracle Native connection.  My name does not have any special characters in it.