Re: Crystal Reports 3/VB4 hangs with Informix-CLI ODBC driver
What I would do: 1. Throw out the Informix CLI ODBC driver and install OpenLink. Use it for both Informix and Oracle. 2. Upgrade to Crystal reports 5.0 (I had the same stupid problems with version 3.0 and never got them resolved.) The above configuration works very well for us. If you don't do the above I have no clue how you can get things to work. Even if someone could help you, I would expect all kinds of future problems. I stopped long ago trying to make old versions of software working. I have other things to spend my time on. If you (or your users) can't "afford" upgrading you sure can't afford to do the project at all. It will be much more costly than an upgrade. This world is this way. As these products have been evolving products I think we have to accept that for now. When you do get it to work, it should work well for several years though. And make sure you use nothing but Windows 95 or NT (if you don't allready). Windows 3.x in this configuration is begging for problems. Richard Spitz <spitz@ana.med.uni-muenchen.de> wrote: :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. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org