Postgres Pro
Downloads
Home   >   mailing lists

Error adding table in Crystal Reports(mult. schemas available) - Mailing list pgsql-odbc

From Godshall Michael
Subject Error adding table in Crystal Reports(mult. schemas available)
Date
Msg-id A596FA3368757645AF862C701495CA000138C9DB@hor1mspmx01.gmachs.com
Whole thread Raw
Responses Re: Error adding table in Crystal Reports(mult. schemas  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-odbc
Tree view
Hi,
 
I have a postgresql database with two non temporary schemas.  I am able to add the tables from the schema named "Public" to my reports but I cannot add tables from my 2nd schema to my reports.
 
I am not trying to add tables from both schemas to same report.
 
I tried using ODBC 7.2X and have upgraded to 7.3.100 and still receive the following error.
"Not Supported. Details:  Cannot obtain error message from server".
 
The account I am using to access both schemas is the same with same permissions set.
 
I am using Crystal 9.0 with SP1 installed on Win2000 SP4.
 
How can I determine if the problem is with postgresql driver or crystal?

Michael Godshall
GMAC Global Relocation Services
900 So. Frontage Road
Woodridge, IL 60517
630-427-2070 office
630-972-2287 fax

michael_godshall@gmachs.com

 

pgsql-odbc by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: Re: Hi!
Next
From: "Rick"
Date:
Subject: (ODBC) Error connecting to postgres 7.2.2