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/
Comments
0 comments
Please sign in to leave a comment.