Setting AFC with PostgreSQL

Victor Teletnichenko

Edited December 24, 2021 18:23

Symptoms

Configuring AFC 12.0.3.4164 connection to PostgreSQL and then receiving this error.

Resolution

To enable PostgreSQL support you should add to c:\inetpub\wwwroot\FlexiCapture12\Monitoring\Web.config string:

<appSettings>
<add key="PostgreSqlEnabled" value="true" />
<appSettings>

Install ODBC driver by the link (I used psqlodbc_12_02_0000-x64.zip):
https://www.postgresql.org/ftp/odbc/versions/msi/

and add it to ODBC Data Source Administrator (64-bit) console as a System DSN.

The driver should has name PostgreSQL Unicode(x64) otherwise you can get an error "Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" when creating a database.

If you install ODBC driver through Stuck Builder driver can have a different name "PostgreSQL ODBC Driver(UNICODE)" so, we recommend to install the driver from the official site: https://www.postgresql.org/ftp/odbc/versions/msi/