Skip to Content
0
Former Member
Aug 21, 2008 at 05:41 PM

Informix ODBC refresh trouble

18 Views

Hello forum,

I am using Crystal Reports XI ver 11.5.8.826 on WinXP Pro to design reports for an Informix database. The connection between the report designer and the database is an Informix ODBC connection, version 3.31. I have other database client applications that are able to access the database through the ODBC connection without any trouble. My Crystal Reports designer, however, is often unable to refresh database information properly, which prevents me from being able to add new database fields to existing reports. To refresh reports, I am using the Database menu item Verify Database. It often returns messages indicating that the report tables no longer exist, even though I am certain that they do. The refresh menu item on tables in the Field Explorer appears to do nothing. I have also tried to re-create the connection in the Database Expert, but this also has no effect. Does anybody have any advice? I am confident that the Crystal Reports designer is the problem, because I run the report query in other DB clients using the same ODBC connection, and they return the expected result.

Thanks,

Paul Oldenburg

Global Crossing Conferencing