QUESTION POSED ON: 30 June 2004
I am trying to update my iSeries data through ASP pages. My connection works for reading just fine, but when I try to update the record the following error message is displayed.
Error Type:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
I am using CA 5.1 with the latest service pack. I have also checked the locktype which is set to *none.
set mConn = server.createobject("ADODB.Connection")
mConn.Open "DSN=DSN_Name;UID=UserID;PWD=Password"
set mRS = server.createobject("ADODB.Recordset")
set mRS.ActiveConnection = mConn
mRS.Open "SELECT * FROM LIB.Obj"
Am I missing something on my connect?
|
