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
Could please someone help me or give me some tip?