KB Article #70463
Connection to "Postgres ver 9" via ODBC on Linux RedHat with XIB 211.
Problem
Resolution
-- 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