Hello All,

I am trying to connect ACE 12 to postgresql database through odbc.
Can anyone did this before?
1, I need a sample odbc.ini file connecting to postgresql
2, should i need to configure the odbc driver explicitly for this?

------------------------------
Anoop C Pillai
------------------------------

Hi Anoop,

We do not ship a Postgresql driver and thus it is not supported and therefore have no documentation.  You can certainly bring an ODBC v3 compatible driver and plugin it into ACE, but you will need to support it.  The closest odbc.ini file I could find is:

[POSTGRESDB]
Driver=/usr/local/lib/psqlodbcw.so
Description=Postgres ODBC Driver
Database=postgresdb
Servername=127.0.0.1
Port=5432

You will need to consult the Postgresql documentation to find the correct options and settings.

Yes, we do have clients that have set this up successfully.

-Matthew

------------------------------
MATTHEW SEGALL
------------------------------

Dear Matthew,

I installed the postgres sql driver manually in the ACE and able to connect postgres db.
But I want to confirm that we did it correctly and make sure that there will be any problem will come in future.
Attached a document contains steps that we followed.

------------------------------
Anoop C Pillai
------------------------------

Original Message:
Sent: Wed January 19, 2022 11:47 AM
From: MATTHEW SEGALL
Subject: ACE 12 to Postgresql connection via ODBC

Hi Anoop,

We do not ship a Postgresql driver and thus it is not supported and therefore have no documentation.  You can certainly bring an ODBC v3 compatible driver and plugin it into ACE, but you will need to support it.  The closest odbc.ini file I could find is:

[POSTGRESDB]Driver=/usr/local/lib/psqlodbcw.soDescription=Postgres ODBC DriverDatabase=postgresdbServername=127.0.0.1Port=5432

You will need to consult the Postgresql documentation to find the correct options and settings.

Yes, we do have clients that have set this up successfully.

-Matthew

------------------------------
MATTHEW SEGALL
------------------------------