Cognos setup (oracle)

[Yizi]

Hi all, I have a few questions. I've setup cognos under MS sql without any issues and got the ODBC/connection working even in DQM but I'm having issues with Oracle.


If oracle 11g is used which driver should be copies? ojdbc5.jar or ojdbc6.jar
Do I only copy it under \webapps\p2pd\WEB-INF\lib or under v5dataserver or both
Is there anything else needs to be done?

Thanks!

[MFGF]

Hi all, I have a few questions. I've setup cognos under MS sql without any issues and got the ODBC/connection working even in DQM but I'm having issues with Oracle.


If oracle 11g is used which driver should be copies? ojdbc5.jar or ojdbc6.jar
Do I only copy it under \webapps\p2pd\WEB-INF\lib or under v5dataserver or both
Is there anything else needs to be done?

Thanks!

Hi,

Does this post help?

http://www.cognoise.com/index.php/topic,25615.msg81161.html#msg81161

Cheers!

MF.

[Yizi]

I get a error for compatible (normal connection in the admin config area) but JDBC on the other hand works.
Error: QE-DEF-0285 The logon failed

Any ideas where I'm going wrong with this, I checked the drivers again and they are in the right place.

[MFGF]

I get a error for compatible (normal connection in the admin config area) but JDBC on the other hand works.
Error: QE-DEF-0285 The logon failed

Any ideas where I'm going wrong with this, I checked the drivers again and they are in the right place.

Hi,

The JDBC drivers you were asking about are only for dynamic query mode - compatible query mode uses the Oracle client libraries to connect. You need to have these installed on your server and your FM machine. You need the 32-bit Oracle client for compatible connections, too! :)

MF.

[Yizi]

Right that makes sense, does this need to be specified in the DatabaseDriveLocations.properties?

[MFGF]

Right that makes sense, does this need to be specified in the DatabaseDriveLocations.properties?

Sorry, I have no idea what that means?

You need to have the Oracle client libraries installed. Assuming you're on a Windows server, Cognos uses coguador. Take a look at this support article for info on setting up and debugging Oracle client connections:

http://www-01.ibm.com/support/docview.wss?uid=swg21341734

Cheers!

MF.