Ask the Expert

Updating iSeries data 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.

This was first published in June 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: