KB Article #70463

Connection to "Postgres ver 9" via ODBC on Linux RedHat with XIB 211.

Problem

-- Is Postgres connectivity tested with XIB211?
-- How to connect to Postgres from XIB211?


Resolution

* Yes, Postgres connectivity is tested with XIB211. However, it is tested with Red Hat Linux 32-bit only.



* Following are the steps to test the connectivity:



Install unixODBC, psqlodbc and PostGresSQL.

Perform the following:



- export LD_LIBRARY_PATH=/something/unixODBC/lib:/something/pgsql/lib:$LD_LIBRARY_PATH
- add to odbc.ini
[POSTGRES_DATASOURCE]
Driver=/something/psqlodbc/lib/psqlodbcw.so
Servername=localhost
Database=your_db_name