Re: Conversion from BDE to ADO

From: eWolverine (eWolverine_at_michigan.net)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 08:02:00 -0600

If you are using BDE stored procedures, you will want to make an adjustment
when using ADO stored procedures. In Delphi 5, the ADO stored procedures DO
NOT have their own "TimeOut" property available to you. You will have to
cast the ADO stored procedure component via a TADODataSet. If you have
stored procedures that run a long time, you will need to set the "TimeOut"
value.

I don't have the code on-hand, but use google or Tamaracka under the topic
"ADO stored procedures + CommandTimeout".

"John Faris" <johnfaris@nospam.hotmail.com> wrote in message
news:40616715$1@newsgroups.borland.com...
> Hi all.
>
> I am currently experimenting with converting a quite large app from BDE to
> ADO. It accesses a MS SQL 2000 database, and before I commit and jump
> headlong into this I wonder if there are any major issues to be aware of?
> One of the main benefits I am hoping for is better multi-user detection
> capabillity e.g. if one user changes a record another has open and then
the
> other user tries to change they get an appropriate error message. I have
> found BDE support for this a little flakey at best. Are there any setting
> changes from the default on TAdoQuery or TAdoConnection that I should
> definitely make? Finally I have seen a fair bit of discussion around
> suggesting that ADO will slow my app down, is this true?
>
> Many thanks for any input.
>
> John.
>
>