SOLVED. XQE-DS-0006 Unable to logon to data source. Help Please!!!

[10e5x]

XQE-DS-0006 Unable to logon to data source while making a JDBC connection to Oracle 11g R2 in Cognos 10.1.1.


Background:
Cognos 10.1.1 64bit
Oracle 11g R2 64bit
Windows 7 64bit OS
IIS 7x

Pros out there help me plssss, I cant find a solution to my problem after googling for long time.

Thanks in advance,
10e5x

[RKMI]

Hi,

Have you entered the tns names/ did a tnsping in your application tier, please have a look at this link: http://www-01.ibm.com/support/docview.wss?uid=swg21341734

Thanks,
RK

[10e5x]

Thanks RKMI for the input, greatly appreciated.
Reading the links now but seems that it is a whole load of info. Quite complicated as i am a first time user of cognos.

Any other input are welcomes as i still on the same error. XQE-DS-0006 when i am testing the connection at cognos connections.

[10e5x]

Hi i did a tnsping in my application tier and read the document you sent but still unable to solve it.

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\L31305>tnsping oracle

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-SEP-2
012 15:29:20

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:
C:\app\L31305\product\11.2.0\dbhome_2\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos
t)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle)))
OK (20 msec)

C:\Users\L31305>

[MFGF]

If you are adding a data source connection from within the Cognos Admin console (from Cognos Connection), you will need to have the Oracle 32-bit client libraries installed to be able to connect. My guess is you have the 64 bit libraries?

Cheers!

MF.

[10e5x]

Solved, and ya you are right. How do i mark this thread as answered? Anyway do you have any experience with using ldap authentication with cognos?
And thanks for your reply MFGF

[MFGF]

Just go back and modify the subject of the first post in the thread to add the word SOLVED. I have done it for you here :)

Yes - I am using LDAP with Cognos 10. Do you have any specific questions?

MF.

[abhinav2006@gmail.com]

I am facing quite similar issue: Please help me in this ...

My data in residing in SQL Server 2008 (ex- Northwind). I am using Cognos 10 Framework Manager to create a model and establish data source connection. While doing so, I get success at first test but It fails at second step. [/img]
Error message:

XQE-DS-0006 Unable to logon to the datasource.
The connection to the host  ,named instance failed. Error: "java.nety.SocketTimeoutException: Receive timeout".Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1433


attaching the error message.

[SG1907]

I am facing the same error XQE-DS-0006...

How do I install Oracle 32 bit lib files to my 64 bit Oracle 11g environment..

Back ground of my environment..

I am installing all the below components in my personal computer..

64 bit Cognos 10.2.1
64 bit Oracle 11g database server for content store database
IIS 6

I do not have oracle client installed in my computer...is it necessary for cognos ?

[MFGF]

I am facing the same error XQE-DS-0006...

How do I install Oracle 32 bit lib files to my 64 bit Oracle 11g environment..

Hi,

That sounds very much like a question you should be asking on an ORACLE forum? We're all Cognos guys here, but one or two might have some ORACLE experience. I'd probably start by reading through this:

http://docs.oracle.com/cd/E11882_01/install.112/e16774/pre_install.htm

Back ground of my environment..

I am installing all the below components in my personal computer..

64 bit Cognos 10.2.1
64 bit Oracle 11g database server for content store database
IIS 6

I do not have oracle client installed in my computer...is it necessary for cognos ?

Yes it is, if you want to use ORACLE as a reporting data source and connect via the native client. If you want to connect via jdbc, then you need the correct ojdbc.jar file. If you want the option to do either, you need both the 32 bit client and the ojdbc file.

For content store access only, you just need the jdbc.

Cheers!

MF.

[sdf]

I think you would only need oracle client installed on computers other than your own computer where cognos and oracle server is installed.

Because your own computer already has access to Oracle.