0

I want to connect Crystal Reports (2016, Support Pack 8, version 14.2.8.3426) to a PostgreSQL 12 database. Using JDBC. The database is on my local computer, on port 5433. My database name: ogc which is in public schema.

I have downloaded the driver:

https://jdbc.postgresql.org/download/postgresql-42.2.12.jar

I extracted the driver.

I changed the CRconfig to:

C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java/lib/postgresql-42.2.12.jar;${CLASSPATH}

I can connect to the database using:

jdbc:postgresql://localhost:5433/ogc

my database class: org.postgresql.Driver

So far so good.

In data explorer I get:

So, the connection is there. However, when I want to select tables to use in the report, I get the error:

Retrieving data from the the database has failed. Details: not implemented.

What am I missing, to use the tables I want?

0

Solved it; my postgres db has the PostGIS extension, and the tables a geom field. The driver does not handle that.

So I copied the table and deleted the geom field.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.