Cognos 10 Postgres ODBC issue - Urgent

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 (
UDA-SQL-0571 The operating system returned an error message ( 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/ /usr/lib64/

Could please someone help me or give me some tip?

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.

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

Steps for setting up ODBC connections on Unix/Linux.