ODBC Data Source for use with Crystal Reports and PostgreSQL

Owned by Scott Friend
Apr 30, 2019
2 min read

To use reports written with Crystal Reports and PostgreSQL an ODBC data source is required.

Instructions

*MS SQL Server does not require an ODBC data source to be set up.

AdamsWeb automatically installs the PostgreSQL ODBC drivers.  It also installs a default ODBC data source named ForayAdams.

This ForayAdams data source may be all you need.  If the following three requirements are met then there is nothing more to do.

  1. PostgreSQL is running on the same machine as AdamsWeb.
  2. PostgreSQL is using port 5432.
  3. The database being connected to is named ForayAdams. *(No longer true as of the 4.6 release)

If any of these three are not true then do the following.

  1. Open the ODBC Data Source Administrator by typing ODBC in the Start menu search field and selecting "32-bit Data Source (ODBC)".  On 32 bit systems this will not have the "32-bit" in front.
    1. On a 64 bit system if you only see one ODBC listing in the Start menu then run: C:\Windows\SysWOW64\odbcad32.exe
  2. Click on System DSN
  3. Select ForayAdams and click Configure...
  4. If the database being access is not named ForayAdams then change both the name of the Data Source and the Database name to be the same as the database name.  Ex: If the database is named ForayAdamsTest in pgAdmin then set both the Data Source and Database fields to ForayAdamsTest.
  5. If PostgreSQL is not running on the same machine as AdamsWeb then enter the database server's name in the Server field.
  6. If PostgreSQL is not using port 5432 then enter the port being used in the Port field.
  7. Test the connection by entering the foraydbadmin User Name and Password and clicking test.
    1. The pg_hba.conf may need to be modified to allow the connection.
  8. Click Save.
  9. Click OK.
  10. Test in AdamsWeb (pool restart not required).




© 2023 Foray, LLC - All Rights Reserved