Re: Dirty Read via ODBC?

One simple solution is to change to the OpenLink ODBC drivers (http://www.openlinksw.com). With their server based driver (not the lite version) you can set this up at the server side. You can have the driver execute any sql statement when someone is loggin in. This is one of the many reasons why you need better drivers than Informix currently supply. With MS Access it might be possible to send a set isolation statement before you start a report. I have however never tried that. I know of no way to do this with Crystal Reports. This kind of thing is of course something you should tell Seagate you want in a future version. Most advanced databases have similar needs these days, and any report writer should support such functionallity. "J Lusty" <jlusty@wrbc.com> wrote: :Does anyone know if MS Access or Crystal Reports has a way to specify an :Isolation Level to Informix OnLine? : :There doesn't seem to be a way to set the Isolation Level to Dirty Read :within the CLI components (SetNet32, Informix ODBC driver ver. 2.5). In :this case, we are using MS Access as a front end, but will likely be moving :to Seagate Crystal Reports. : :Thanks. 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