Re: Cursor stabilty over ODBC

Posted in 1998

Allan Gould — Tue, 28 Apr 1998 15:02:21 +0100 — source: Informix-list mailing list archive (1991-1998)

Nils Myklebust wrote: > On Mon, 27 Apr 1998 16:58:29 +0200, "Guido Brunner" > <xpass20@dresdner-bank.de> wrote: > > >we are running Informix 7.14 UD1 on AIX V4 and the users connect via MS > >Access 97 and Informix CLI 2.5 running under NT. > > > >Our Infomix database are created in ANSI mode. In this mode every connect to > >the database uses the isolation "repeatable read" no matter if data is > >updated or only read. Some problems raise when "read"-users lock the > >database. > > > >Is there any possibility to set isolation to "cursor stability" as a default > >for "read"-users ? > > If you change to the Openlink ODBC driver it supports sending such > statements to the database upon connection by spesified users and/or > spesified applications executed. Ditto SQL-Retriever: with the -f flag on the daemon, SQL commands in a given file will be run on connecting. http://www.sco.com/vision/products/sqlretriever/ for more information and a downloadable eval. Allan Gould (allang at sco dot com) (Please remove anti-spam measures if replying)