Using Crystal Server with PostgreSQL database

[Former Member]

Hello everyone.

I've installed a free trial of Crystal Server 2011 on my Windows 7 machine to try the reporting solution with my PostgreSQL database, however I'm having some troubles. After the installation I head into Central Configuration Manager to try and add my database.

I add a new node with CMS, enter name and port.

When I am asked to provide the datasource I'm only given a limited number of options for the driver none of which works with PostgreSQL:

SAP HANA (ODBC)

SQL Server (ODBC)

Oracle

DB2

Sybase

MySQL

MaxDB

SQL Anywhere (ODBC)

When I try to use any of those and then select my PostgreSQL ODBC data source (I have created it in Data Sources in Windows control pannel) it tells me it is not supported.

Shouldn't there at least be Generic ODBC? Is PostgreSQL even supported by Crystal Reports? I can connect to that database just fine with a Crystal Reports desktop program, but I would like to use server solution. Can somebody please advice how can I get this setup running?

[former_member205064]

PostgreSQL database is not supported for CMS DB Check PAM

For Reporting DB its supported check the Data Access secion in the PAM.