If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos 10 Postgres ODBC issue - Urgent

Started by leank, 26 Jul 2011 03:07:41 PM

Previous topic - Next topic

leank


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?