Error on Creating new Data Source

[Mahendra]

Hi Gurus'

When I am creating a new Data Source from Cognos connection its giving the below error m
message can any body suggest on this.

QE-DEF-0285 The logon failed.
QE-DEF-0285 The logon failed failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to
1 databases(s) in:testDataSourceConnection


UDA-SQL-0432 Unable to locate the gateway "cogudaor".
RSV-SRV-0042 Trace back.


Its Urgent please help me.

Thanks in Advance.
Mahi

[MFGF]

Hi,

I assume this is a connection to Oracle?

This might be a good place to start:

https://www-304.ibm.com/support/docview.wss?uid=swg21341734

Regards,

MF.

[Mahendra]

Hi MFGF,

Thx for ur quick responce,

I forgot to say that we are newly installed cognos in a new server, which is 64 bit
and the Oracle data base is also installed in 64 Bit, is this causes any problem.

here we are getting the above problem.

Thanks
Mahi

[navissar]

Cognos requires 32-bit client libraries to connect to Oracle as datasource. This means you need to have an Oracle 32-bit client *of the same version as the database server* installed on the Cognos machine to get it to connect.

[MFGF]

You will need to use the 32 bit Oracle client libraries to be able to connect from Cognos 8.

Regards,

MF.

Edit - I have been beaten to it!! :-) 

[navissar]

Jinx! :)

[MFGF]

You were quick on the draw there! :-) Beat me to it fair and square! :-D

[Mahendra]

Hi All,

Thanks for ur help,

Still we are facing problem we Uninstalled the Oracle which is installed
in 64 Bit, and reinstalled into 32-Bit

Other things,Conecction and all working fine,Except the creation of DateSource Connection from
from Cognos Connection.

Thanks
Mahi

[MFGF]

Did you work through all the steps in the document link I sent to you?  They are usually pretty good at helping you to troubleshoot these kinds of problems.

Regards,

MF.

[sir_jeroen]

are the tnsnames.ora accessible? What happens if you do a tnsping?

[SGD]

I had similar problem with datasource connection and following below steps it resolve. I have documented this for future use.

CAN NOT CREATE DATASOURCE CONNECTION IN COGNOS 8.4.1 WITH ORACLE 11G DATABASE SERVER:
• Cognos 8.4.1 displays below error message when database connection is not established between Cognos 8.4.1 server and Oracle 11g database Server.
• Cognos Server (64 bit) is not able to connect with Oracle 11g (64 bit) database server though both the applications are compatible with each other.
• IBM Cognos supports 64-bit data sources via 32-bit connectivity. Hence, IBM Cognos 8.4.1 requires 10g Oracle 32-bit database client to connect with Oracle 11g 64-bit database application.
• Please refer below IBM sites for more clarification:
http://download.boulder.ibm.com/ibmdl/pub/software/data/cognos/support/en/products/Cognos84_64-bit_Jan2009.pdf
http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14472653
http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14608083

• Cognos 8.4.1 displays below error message after installation of Oracle 10g 32-bit client on Cognos Server machine.
• Because installed Oracle 10g client is 'instant' client also with '10.2.0.1' version.
• To resolve this issue Oracle 10g 'Full' client has to be installed instead of 'Instant'.
• In addition to Oracle 10g Full client version should be 10.2.0.3 and above since Cognos Server is installed on Win 2003 SP2 Enterprise Edition 64-bit Operating System.
• Please refer below IBM sites for more clarification:

https://www-304.ibm.com/support/docview.wss?uid=swg21340273
http://www.ibm.com/developerworks/forums/thread.jspa?threadID=323540

• Thus, need to install Oracle 10g R2 (10.2.0.3/10.2.0.4) client on Cognos server and which can be downloaded from here http://www.oracle.com/technetwork/database/10203vista-087538.html

• User has to copy and paste 'ojdbc14.jar' file from '...\oracle\product\10.2.0\client_1\jdbc\lib' folder path to '...\Program Files (x86)\cognos\c8\webapps\p2pd\WEB-INF\lib' folder path after installation of Oracle client 10g v10.2.0.3.
[/list]