Personally, I’d view the SQL behind the reports (you can do this in Crystal 8, I’d think you can do it in 6 as well), and run the SQL command directly against the database server (i.e. through psql, or a management tool.)
That will give you a more reasonable indication as to what’s going wrong.
If the SQL runs fine on the server ,you need to be looking at the ODBC driver configuration.
Are you using ODBC or OLE DB to access PostgreSQL?
Andy
From: pgsql-interfaces-owner@postgresql.org [mailto:pgsql-interfaces-owner@postgresql.org] On Behalf Of Makarand Kulkarni
Sent: 17 June 2006 6:10 am
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] Report Interface problem with Crystal Report 6.0
Dear Sir,
I am using Crystal Report 6.0 on Windows XP Pro platform. The VB application currently uses MS Access database and Crstal report 6.0 report tool. I am now chaning the database to PostgreSql. The conversion has been successful, but some of the reports do not work. There are @ 90 reports in the software out of which 6 reports work perfectly. For others I get “Automation Error”
What could be the problem and the solution for the same?
Regards,
Makarand Kulkarni
!DSPAM:14,4493f912256841211711626!