Re: MS Access & Informix Workgroup edition

"Art S. Kagel" wrote: > Just SET LOCK MODE TO WAIT 10; then the client session will wait for > 10 seconds for any transient locks to clear before returning a lock error. > Unless your apps are poorly designed most locks are transient so this is > the correct solution. > > Art S. Kagel > > nonbeliever wrote: > > > > We may be a little behind the times, so bear with me on this one :) > > > > We just upgraded from "Standard" engine to "Workgroup" Informix engine. > > Since doing that we are getting record locks - OK no problem with dbaccess - > > just use 'set isolation dirty read'. Big problem with Microsoft Access > > using the Merant ODBC drivers. We can not find a way to make MS Access > > utilize the dirty read. Instead all we get are ODBC errors indicating > > record locks. > > > > Can anyone let me know how to set MS Access to dirty read? > > > > Thank you all in advance - this is my first time posting, but have read this > > board for a couple of weeks and learned many new (to me anyway) things! > > Keep up the good work! I don't know if the same applies to the Merant ODBC Drivers but with the CLI ODBC Drivers if you issue a set lock mode to wait this has only effect for the specific session and not for any others that are subsequently created by the client application. If you issue a onstat -g ses to discover these sessions and then a onstat -g ses sid to see the details of each session you will noticethat in the Lock Mode Column of the session belonging to other statements the status is "Not Wait" where in the Lock Mode Column of the session belonging to the SET LOCK MODE TO WAIT statement is correctly set to "Wait". The same applies if you try to issue a SET ISOLATION TO statement. I think that the Openlink ODBC Drivers provide the possibility to set things like that for all sessions that are created. For the Informix CLI Drivers the only solution was to create a stored procedure where you set the lock mode and execute your select statement and then execute the SP from your MsAccess Code. HTH Tolis Varnas -- V+K Relational Solutions mailto:tvarnas@compulink.gr Deligiorgi 26 mailto:tvarnas@orbit.de 546 42 Thessaloniki Voice: +30-31-820270 Greece Fax: +30-31-865463