Re: Conversion from BDE to ADO

From: Kevin Frevert (Work_at_drinkingcoffee.com)
Date: 03/24/04

  • Next message: David Smith: "Delphi 6 and ADO OLE DB Directory Services" 
    Date: Wed, 24 Mar 2004 05:54:25 -0600

    John,

      I've noticed no performance problems with ADO and MSSQL. In fact, we
    (currently) have no problems with the BDE (we are still in the process of
    conversion). Our primary customer service app has run against MSSQL 6.5,
    7.0 and now 2000 with no code modifications.

    Here is some additional info..
    http://bdn.borland.com/article/0,1410,27790,00.html

    Good luck,
    krf

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

  • Next message: David Smith: "Delphi 6 and ADO OLE DB Directory Services"

    Relevant Pages

    • Re: Speed problem with mssql 2000 and ado
      ... > We are evaluating ado with delphi 7. ... Our application uses the bde to ... Now we are using nvarchar and ntext in our mssql ... > With Oracle we have no speed problems. ...
      (borland.public.delphi.database.ado)
    • D7 & ADO with ASA9: EOLEException & Multiple-step error
      ... If I rest my pointer over the ".AsString" part of AdoDataMod.aquGetClipReadOnly.FieldByName.AsString, I get the yellow ribbon hint with the text "Delphi Exception EoleException at ... I tried removing the fields from the ADO query, I tried adding them back in again, I tried closing everything 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. ...
      (borland.public.delphi.database.ado)
    • 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)
    • 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: Enhancing ADO Performance
      ... > currently have applications constructed to retrieve data from ODBC ... > worked with both because of the installation issues when using the BDE ... It seems that ADO ... of data and hooking to a DB grid, use a server-side cursor. ...
      (borland.public.delphi.database.ado)