RE: DB2 on AS400

["John Taylor" <jtaylor@xxxxxxxxxxxx>]

Pillai,

 

You're message was scrambled pretty badly by your email system. Send it again --as plain text-- and maybe we can help once we can see the code.

 

 

John Taylor

-----Original Message-----
From: owner-web400@midrange.com [mailto:owner-web400@midrange.com]On Behalf Of Pillai, Sushama
Sent: Monday, July 23, 2001 4:36 PM
To: WEB400@midrange.com
Subject: DB2 on AS400

DB2 on AS400 Hi all, I am trying to connect to a table on =he AS400 using ASP and I get the following error : ADODB.Fields error =800a0cc1' ADO could not find the object in the =ollection corresponding to the name or ordinal reference requested by =he application. The error point to the following =ine: Here is a part of my code: Set cn = =erver.CreateObject("ADODB.Connection") cn.Open =Provider=IBMDA400; Data Source=AS400;", "abc", =xyz" Set cm = =erver.CreateObject("ADODB.Command") Set =m.ActiveConnection = cn Set rs = =m.Execute with rs Do While Not =Eof <% =MoveNext Loop end =ith It seems it is connecting =uccessfully but not understanding the fields. I would appreciate it if =omeone could tell me what I am doing wrong. I verified that the table =ame and the field names are correct. Thanks in advance. Sushama