Re: D2005 ADO problem: multiple-step OLE DB operation generated errors


> I migrate my ADO application from Delphi 7 to Delphi 2005. everything
>compiled OK,
>but in run time, when I open a table, error occurs: multiple-step OLE DB
>operation generated errors.Check each OLE DB status value, if available. No
>work was done.
> What thanges of ADO between Delphi 2005 and Delphi 7? my application run
>fine when compiled with delphi 7!
>
> how to resolve this problem?
The most frequent cause of this error is to have persistent Tfields saved where
a saved field type does not match the field types the query is returning.
Try deleting the Tfields for the tadoDataset you are opening and recreating
them
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Delphi 8 and ado.net
    ... > different to using say ADO in Delphi? ... The Delphi ADO implementation is basically a wrapper around the Recordset ... have cursors into the database, there are no cursors in ADO.NET. ...
    (borland.public.delphi.non-technical)
  • Re: Sub Selects?
    ... > some nice Delphi DB technique to do this, or should I just build up the ... Due to the way that the ado ... lets assume that you have a list called SelectedIds ... I'd recommend against using the filtering method. ...
    (borland.public.delphi.database.ado)
  • Re: recursive sp, fmtonly, ado,
    ... This was the first thing I've checked, because I suspect Delphi. ... It's in somewhere inside ADO or OLEDB. ... >> create procedure fmttest ...
    (microsoft.public.sqlserver.programming)
  • Re: Field position in a record, how to change?
    ... If you know how to move fields with DAO you can use Ole to access the ... I have found how to obtain the (ADO) FieldDefs for the ... (I am searching documentations for this option but your answer might ... I may just have found the answer in my saved Delphi 5 help files ...
    (borland.public.delphi.database.ado)
  • Re: slow ADO refresh, ending in error message
    ... It seems to me that if the feature works fine with some implementations ... with Delphi 7) and poorer with other implementations (the Delphi 7 ... >>Is ADO only for small databases then? ... > You can use any size database with ADO but if you want good performance you ...
    (borland.public.delphi.database.ado)