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.
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?
To get an updateable result set use the statement "select a,b,c from myfile for update."
================================== MORE INFORMATION ON THIS TOPIC ==================================
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: Tips, tutorials and more.
PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.
This was first published in June 2004