Manage Learn to apply best practices and optimize your operations.

Updating iSeries data through ASP pages

How to update an iSeries through ASP pages

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?

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.

Dig Deeper on Remote Access to iSeries

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.