Apr 25, 2001 #1 Mike25 Programmer Apr 25, 2001 2 US I need to know how I can connect to an Informix database in read only mode.. In informid read only = set isolation to dirty read.
I need to know how I can connect to an Informix database in read only mode.. In informid read only = set isolation to dirty read.
May 2, 2001 #2 jonscott8 Programmer May 12, 2000 1,317 US SET oConn=CreateObject('ADODB.Connection') oConn.Open "MyDsn" oConn.Execute("SET ISOLATION TO DIRTY READ" Now any query executed thru this connection will be done so in dirty read mode: SET oRS = oConn.Execute("SELECT * FROM MyTable" Jon Hawkins Upvote 0 Downvote
SET oConn=CreateObject('ADODB.Connection') oConn.Open "MyDsn" oConn.Execute("SET ISOLATION TO DIRTY READ" Now any query executed thru this connection will be done so in dirty read mode: SET oRS = oConn.Execute("SELECT * FROM MyTable" Jon Hawkins