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!
Quote from: Yizi on 19 Aug 2014 07:35:09 AM
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.
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.
Quote from: Yizi on 20 Aug 2014 04:43:58 AM
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.
Right that makes sense, does this need to be specified in the DatabaseDriveLocations.properties?
Quote from: Yizi on 20 Aug 2014 05:37:35 AM
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.