DB2 on AS400

["Pillai, Sushama" <spillai@xxxxxxxxxxxxxxxxxxxxxxxx>]

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