× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. WEB400
  3. July 2001

RE: DB2 on AS400

  • Subject: RE: DB2 on AS400
  • From: "John Taylor" <jtaylor@xxxxxxxxxxxx>
  • Date: Mon, 23 Jul 2001 20:02:37 -0600
  • Importance: Normal
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

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.