Re: Dirty Read via ODBC?

J Lusty <jlusty@wrbc.com> wrote in article <01bca11a$1fd314c0$a00101c0@bis005392>... > 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. With Informix CLI, I don't know of any way. With OpenLink Multi-Tier ODBC drivers, which include a server component, you can define a file which holds a set of initial SQL statements to be executed for each new connection. I've used this to set both the isolation level and pdqpriority for users using MS-Access as an ad-hoc query & reporting tool. You can define different initial SQL files (as well as many other parameters) based upon user id, host name/address, application name, etc. I'll avoid any further testimonials here and simply point you at http://www.openlinksw.com for more information. HTH -- Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com