Datasource Creation Problem

[kalyan_sekhar1]

Hi All,

While creating the Datasource i am getting the following error:

---------------------------------------------
QE-DEF-0285 The logon failed
QE-DEF-0325 The logon failed for the following reason:
QE-DEF-0068 Unable to connect tp atleast one database during a multi-database attach to 1 database(s)in: testDataSourceConnection

UDA-SQL-0432 Unable to locate the gateway "cogudaor"

-----------------------------

Does any body faced the same issue, if so can u please let me know on how to proceed on this issue ?

Thanks

[Darek]

Is ORACLE in the PATH

[kalyan_sekhar1]

Yes its there, infact in this box earlier installed Cognos MR1.3 which worked fine. I uninstalled the MR1.3 and installed Cognos 8. Now i am getting the Issue. This is how the PATH is set

C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin

Please let me knwo if u r referring to any other PATH

Thanks

[Darek]

Can you sqlplus to the DB ?

[JGirl]

Have you only just installed the oracle client software??

If yes, you must reboot the computer so that all the oracle stuff gets registered properly....

J

[kalyan_sekhar1]

Hi Darek,

Yes from the box where cognos is installed i can connect to DB using SQLPUS.


Jgirl,

Infact i restarted the system almost 10times but still no luck ...  :'(

Thanks

[RudiHendrix]

I'm having the same problem.
I can use SQL Developer to connect to the database from my server and from the machine where I have installed framework manager. But I'm not able to create a connection from Cognos administration.

I'm using Cognos 8.4.

What should be a correct SQL*Net connect string for Oracle?

[kulkarni]

Hi All,

While creating the Datasource i am getting the following error:

---------------------------------------------
QE-DEF-0285 The logon failed
QE-DEF-0325 The logon failed for the following reason:
QE-DEF-0068 Unable to connect tp atleast one database during a multi-database attach to 1 database(s)in: testDataSourceConnection

UDA-SQL-0432 Unable to locate the gateway "cogudaor"

-----------------------------

Does any body faced the same issue, if so can u please let me know on how to proceed on this issue ?

Thanks

Kalyan,

I am not sure if you have looked at this KB
http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&context=SSWGNW&q1=cogudaor&uid=swg21343258&loc=en_US&cs=utf-8&lang=en

Can you confirm, this is not the case in your scenario?

[RudiHendrix]

Kulkarni: Thanks a lot for this solution!

It helped me a lot! I really hate the fact that the error message is the same for entering wrong values as when having a 64bit Oracle client. But now the problem is solved!