Re: DB2 on AS400

Hi Sushama,

If possible, please try posting to this list in plain text, not HTML -- it's
kind of hard to read your code as you can see below.

Where exactly in the code is it getting the error? I seem to remember
getting this when trying to do a Set instead of a Let.

Regards,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


----- Original Message -----
From: Pillai, Sushama
To: WEB400@midrange.com
Sent: Monday, July 23, 2001 3:35 PM
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


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

+---
| This is the WEB400 Mailing List!
| To submit a new message, send your mail to WEB400@midrange.com.
| To subscribe to this list send email to WEB400-SUB@midrange.com.
| To unsubscribe from this list send email to WEB400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---