App Connect

App Connect

Join this online user group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  ACE 12 to Postgresql connection via ODBC

    Posted Tue January 04, 2022 01:34 AM
    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
    ------------------------------


  • 2.  RE: ACE 12 to Postgresql connection via ODBC

    Posted Wed January 19, 2022 11:47 AM
    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
    ------------------------------

    Original Message


  • 3.  RE: ACE 12 to Postgresql connection via ODBC

    Posted Thu January 20, 2022 01:07 AM
      |   view attached
    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
    ------------------------------

    Attachment(s)

    docx
    IBM ACE _Postgresql _ODBC v1.0.docx   1.60 MB 1 version
    Original Message


Related Content