× 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. MIDRANGE-L
  3. July 2003

Re: Access "non-SQL" databases with ADO?

Loyd

There's no distinction between DDS-defined files and SQL-defined files in terms of access - and SQL table is just a physical file, after all. But I wonder if it's looking at the correct library - if it is using SQL naming, and you don't qualify the filename, it'll try to use your user name.

Is there a joblog in a QZDASOINIT job, or whatever job is handling your requests? This may give a better clue.

Hope this gets in a fruitful direction. (Oy, what a mix of images)

Vern

At 07:34 AM 7/15/2003 -0500, you wrote:
I didn't see anything relevant in the archives...

We're using ASP (not .NET) and ADO to access databases on SQL server.
However, there's also some AS/400 databases we need to access. I've found
that I can use ADO against "SQL-defined" databases on the AS/400, but I
can't query files defined by DDS. DDS defined files get this error:

"Error Type: ADODB.Recordset (0x800A0CC1) Item cannot be found in the
collection corresponding to the requested name or ordinal."

The line receiving this error is:

response.write "<tr><td>" & rsq("name") & "</td><td>" & rsq("company") &
"</td><td>" & rsq("id") & "</td></tr>"

All three fields are character types. It doesn't matter if the field names
are in upper or lower case, I receive the same error.

Any help appreciated, thanks!

Loyd

--
Loyd Goodbar
Programmer/analyst
BorgWarner Incorporated
ETS/Water Valley
662-473-5713
lgoodbar@xxxxxxxxxxxxxx



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-2025 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.