I am using Crystal Reports XI ver 184.108.40.2066 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.
Global Crossing Conferencing