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
Is ORACLE in the PATH
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
Can you sqlplus to the DB ?
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
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
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?
Quote from: kalyan_sekhar1 on 08 Feb 2006 09:04:22 AM
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?
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!