Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Informix + VB

Status
Not open for further replies.

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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top