Connecting Oracle 10 XE to IBM Cognos Express
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!