Crystal Reports 3/VB4 hangs with Informix-CLI ODBC driver
Posted in 1997
Hi, I have a problem with Crystal Reports for Visual Basic 4. It works fine when I access an Oracle database via Oracle's ODBC driver 7.3 or when I access our Informix-Online server (Online 5.07UC1) via an older Intersolv ODBC driver. However, when using the ODBC driver from Informix-CLI 2.0, I can connect to the database and get the list of tables displayed. When I then select any table and click "OK", Crystal Reports hangs completely, there is no response to the keyboard or the mouse and I have to kill CR with "CTRL-ALT-DEL". While CR is hanging, the database connection is still open, and "tbmonitor" shows the sqlturbo process hanging in the beginning of a transaction. I already downloaded and installed the CR patch that is available from Seagate Software, but that didn't help. The German hotline wasn't much help, either, the only thing they suggested was to upgrade to CR5.0. Another related question: When I integrate a CR report into a VB application, will the report use the same ODBC connection that the application already has, or will it open a new connection? If the latter is true, can I use the CLI-ODBC driver for my VB data connection and the older Intersolv driver for the CR data connection? Just so I can continue with my present project, the driver problem must absolutely be resolved. Regards, Richard -- +--------------------------+------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +--------------------------+------------------------------------------+