D7 & ADO with ASA9: EOLEException & Multiple-step error



Good day!

I'm using D7 with ADO, connecting to an ASA9 database.
I am converting the application from an older version using BDE.

I have a DateTimeStamp field in this particular table (among about 30 other fields, including dates). I retrieve a single record for display purposes. Ass goes well until...

At run-time, I can not access the DTStamp field data of the ADOQuery (should contain something like 2003-06-23 11:58:05.809) in Debug mode. If I rest my pointer over the ".AsString" part of AdoDataMod.aquGetClipReadOnly.FieldByName('DTStamp').AsString, I get the yellow ribbon hint with the text "Delphi Exception EoleException at $3E2F949". Same thing if I switch from ".AsString" to ".AsDateTime".

If I continue anyway (F8), I get a Message window titled "Debugger Exception Notification" with the message:

[Project IMC5.exe raised an exception class EoleException with message "Multiple-step operation generated errors. Check each status value"]

What is a multiple-step operation?
What status values should I check?

All the other fields (integers, varchars, dates, etc...) in the ADOQuery are fine.

I tried removing the fields from the ADO query, I tried adding them back in again, I tried closing everything (including the DB Service) and rebooting - so far so bad...
The BDE version has been working with identical data for nearly 10 years without a hitch - it still is.

I looked for references to this in the newsgroups and on various Web sites - did not find much.
Am I the only one with this problem?

Thanks for any info or pointers you may provide.

J. Nicolet
.



Relevant Pages

  • Re: BDE support??
    ... > We have an application that is using controls descended from TDatabase, ... > we'd like to convince the higher ups to ditch the BDE and move to ADO. ... Very nice for unit testing, ...
    (borland.public.delphi.non-technical)
  • Re: Conversion from BDE to ADO
    ... I've noticed no performance problems with ADO and MSSQL. ... conversion). ... > I am currently experimenting with converting a quite large app from BDE to ...
    (borland.public.delphi.database.ado)
  • ADO and BDE interact on XP SP2?
    ... It uses the BDE ... indirectly to connect to a database. ... also optionally uses ADO to connect directly to the database for ... but of course any built in initialisation will have taken place. ...
    (borland.public.delphi.database.ado)
  • Re: ADO.NET Not Returning Error
    ... > a catch (Exception e) so the error should be captured if there is one. ... > but I get nothing back from ADO for this statement. ... > queries and when a user types in a query of this format, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problems using ADO with multi threading
    ... ListIndexOutOfBounds is VCL (not MS ADO) exception, ... create new data module instance for every thread. ...
    (borland.public.delphi.database.ado)