I am trying to create a report through SQL in crystal reports XI and the databass is postgresSQL, but I get an error:
Failed to retrieve data from the database.
Details: ADO Error Code: 0x80004005
Source: Microsoft OLE DB Provider for ODBC Drivers
Description: ERROR: relation"tablename" doesnot exist;
error while executing the query
SQL State: 42P01
Native Error" 7 [Database Vendor Code:7]
The query runs fine, when I run it through Postgres studio.
I would appreciate if somebody could help me with this issue