Q

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.


This was first published in June 2004

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.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close