Errors with ODBC Data Source and Crystal Reports

Problem

If the ODBC data source can't connect and Adams Web throws a Crystal Report error, the issue might have to do with the how the pg_hba.conf file is configured. 

Example of the error: Crystal Reports failed to logon to the database. 

Solution

On the server, the ODBC data source might be pointing to the wrong location for the PostgreSQL ODBC driver.  The configuration file is located in C:\Program Files\PostgreSQL\<version>\data.  Make sure add the fe80::/10 address line. 

# TYPE  DATABASE        USER                ADDRESS                METHOD

# IPv6 local connections:
host    all                      postgres            ::1/128                   trust
host    ForayAdams       foraydbadmin    ::1/128                   md5
host    ForayAdams       foraydbadmin    fe80::/10                md5

-- NOTE: This line is in the Foray Adams Installation Guide.



© 2023 Foray, LLC - All Rights Reserved