Crystal Reports 2020 is now 64 bit and will require a 64 bit PostgreSQL ODBC driver to develop or edit reports.


The current 64 bit PostgreSQL driver can be downloaded from;

https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_13_00_0000-x64.zip


A. If you have previously configured the 32 bit OBDC PostgreSQL driver for Crystal Reports


These instructions are to be performed on machine that is running Spire Server and has the Postgres database server installed.


  1. Unzip the downloaded file and install the driver

  2. Start the ODBC Data Source Administrator (64-bit)

  3. You should see that the 32 bit DSN for PostgreSQL35W was copied over and it should look like this;



Crystal Reports 2020 will now work on the PC for report development.



B. If you did not have the 32 bit ODBC PostgreSQL driver for Crystal Reports

  1. Unzip the downloaded file and install the driver

  2. Start the ODBC Data Source Administrator (64-bit)

  3. The screen will like this, click the Add button



  4. The screen will look like this, Scroll down and select the PostgreSQL Unicode(x64) and click Finish



  5. The screen will look like this, fill it in as shown;


    *Note: You need to have a Company in Spire Server Administration where the database name is "SampleData" - this field is case sensitive.

    Use the the password for the "postgres" user that was set up when Spire Server was first installed, the same password is used to access pgAdmin - this field is case sensitive

    * Note 2: Alternatively, you can use "spireapp" in the User Name field and fill in the password found in c:\programdata\spire\spired.ini file

    The password is found on the line that looks like the line below and the password is between the ":" and the "@" as highlighted, this field is  case sensitive;
    dburl =postgresql://spireapp:,b6!nbtGrtkmLpz^@localhost/spire

  6. Click Test and you should will this;

    If not, then you have an error in the Database, User Name or Password fields.

  7. Click OK, then Save and you will see this;


    Click OK and the ODBC driver is ready for Crystal Reports to use with Spire reports.