Cognos 10 Postgres ODBC issue - Urgent

Cognos 10 Business Intelligence Cognos 10 Administration
1

Hi Guys.
I have Cognos 10 on RedHat 64 bits server installed on Server2. Cognos is UP and working fine.
My problem is to create a datasource on Cognos Connection poiting to Postgres DB installed on server2.

Check the error msg when i Try to create a datasource on Cognos portal

RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: testDataSourceConnection
UDA-SQL-0569 Unable to load the driver manager library (libodbcinst.so)
UDA-SQL-0571 The operating system returned an error message ( libodbcinst.so: cannot open shared object file. No such file or directory)

I have the Postgres ODBC installed and working fine with unixODBC, I can connect using isql from server1 (where Cognos is installed) to server 2 (where Postgres DB is installed)

The files /etc/odbcinst.ini and /etc/odbc.ini were properly configured

And I also created a link for the file mentioned above , like below

[root@srvlinux2 ~]# ln -s /usr/lib64/psqlodbc.so /usr/lib64/libodbcinst.so

Could please someone help me or give me some tip?

2

I haven’t tried a Postgres connection yet but I used Virtual View Manager to successfully connect to MySQL. If you have Virtual View Manager, definitely go that route.

http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=/com.ibm.swg.im.cognos.vvm_installation_guide.10.1.0.doc/vvm_installation_guide.html

3

Thanks for the tip, will try to check if this can help, because until now i couldn’t get sucess.

4

Steps for setting up ODBC connections on Unix/Linux.
http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.inst_cr_winux.10.1.0.doc%2Finst_cr_winux_id24370SettingUpODBCConnections.html