Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connecting Oracle 10 XE to IBM Cognos Express

785003Jul 14 2010
Hello,

I´m trying to connect IBM Cognos Express to an Oracle 10 XE Database.
The OS is Windows Server 2003 x64.

I installed the XE Client and configured the tnsnames.ora in C:\XEClient\bin.
The SQL Command line works fine, but when I try using this configuration in Cognos I get the errorcode ORA-12154.

I tried installing the expressinstall odbc driver, but it isn´t listet in the availible drivers for System DNS creation.
I found them in the "SysWOW64"-Version of the ODBC tool, but get the same error as I get from Cognos.

The same configuration works fine with Windows XP.
What can be wrong?


I´ve read many threads before and used google as best as I can, but I haven't foun a solution yet.

Thanks a lot!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2010
Added on Jul 14 2010
0 comments
919 views