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.
Related articles
© 2023 Foray, LLC - All Rights Reserved