Problem

-- How to use PostgreSQL database with B2Bi MBC's

Resolution

* Check if the file odbc3_UnixODBC_post_2_2_14.db is present <B2Bi_install_directory>/Integrator/4edi/dbload

* Unzip the following archived postgres_package.tgz (see attached) anywhere on your environment.*Set the environment variable ODBCINI to the full path of the easysoft/unixODBC_post_2_2_14/etc/odbc.ini file. (this file odbc is inside the archive from the step 1)

* Go into <B2Bi_install_directory>/Integrator/config/environment.dat and add the full directory of the db/pgsql/lib and the easysoft/unixODBC_post_2_2_14/lib for the variable LD_LIBRARY_PATH

* Edit odbc.ini to put the full path of the .so file in POSTGRES_DATASOURCE -> you need to point to the driver part to the actual path of the psqlodbcw.so (in my case is in /home/admin/postgres_package/db/postgres_odbc/lib/psqlodbcw.so)

* Example for MB call in the MBC : DATABASE OPEN "POSTGRES_DATASOURCE" TYPE "Odbc_3_UnixODBC_post_2_2_14";