Informix 2.8 and ADO ActiveConnection
Posted in 1999
I've been using Informix-CLI 2.5 32 bit driver and recently installed the Informix 2.8 32 bit driver. The following code works without problems with Informix 2.5: 1 Set rs = server.CreateObject("ADODB.Recordset") 2 rs.CursorLocation = adUseClient 3 rs.Open sql,conn,adOpenStatic,adLockReadOnly 4 Set rs.ActiveConnection = nothing 5 Set Session( myset ) = rs Line 4 of the previous code now errors out when using the Informix 2.8 driver: ADODB.Recordset error '800a0e79' The operation requested by the application is not allowed if the object is open Anyone have any suggestions?? I would rather not have to use arrays, if possible Thanks in advance Barry Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.