Q: What change in the URL definition is required by the ODBC driver? A: The URL definition must include a Data Source Name (DSN).
Q: Where is the DSN defined? Is it set at the operating system (OS) level, at the app server level, or somewhere on the AFX server? A: Define the DSN in the Operating System. See your PostGreSQL documentation on defining the DSN.
Q: Where does the ODBC driver for PostgreSQL need to be installed? A: The ODBC driver for PostgreSQL needs to be installed in the connector lib directory. This directory is located at: $AFX_HOME/esb/apps/AFX-CONN-{connector-name}/lib.
Q: Are there any known limitations of the PostgreSQL ODBC driver that would prevent an ODBC connection to a PostgreSQL endpoint when using the Generic Database connector? A: There are no known limitations. |