ADO and BDE interact on XP SP2?

From: Paul Redstone (paul.redstone_at_solica.com)
Date: 08/30/04

  • Next message: George Kuasha: "Querying two separate connections" 
    Date: Mon, 30 Aug 2004 13:54:23 +0100

    Hi

    I have a program, in use by many thousands of users. It uses the BDE
    indirectly (via a third party application API) to connect to a database. It
    also optionally uses ADO to connect directly to the database (read only) for
    higher performance.

    We've had reports of it failing just after XP SP2 is installed indicating a
    problem when BDE tries to initialise its connection to the database. We can
    reproduce this here.At this point the ADO components have not been used in
    any way, but of course any built in initialisation will have taken place.

    A separate test program without the ADO worked fine. Removing the ADO
    components from the full application also worked fine.

    Conclusion: the ADO initialisation component is causing the BDE problems but
    only on XP SP2 (works fine on SP1, Win 2k etc etc). Checking MDAC shows
    version 2.81 on the SP2's machine. Tried installing MDAC from Microsoft and
    it says that it cannot as it is incompatible (presumably with SP2 - probably
    a newer version).

    Development environment is Delphi 5 enterprise on Win 2k Professional.

    Any ideas?

    Paul

  • Next message: George Kuasha: "Querying two separate connections"

    Relevant Pages

    • Re: Suggestoins for Local DB to use with Shareware
      ... It was with D3 - I was using the BDE at the time. ... As for my own experience I begin to evalute ADO with Access ... MDB files in D4 just before D5 appeared with built in ADO support what has ... local database engines and I will continue to use it in the future. ...
      (borland.public.delphi.non-technical)
    • Re: BDE -> ADO
      ... your discussion has more encouraged me to switch to ADO ... My database is SQL SERVER 2000, BDE engine, an ERP ...
      (borland.public.delphi.database.ado)
    • Re: Speed problem with mssql 2000 and ado
      ... to not bother MS SQL Server with 1000 sequential calls for different ids, ... > We are evaluating ado with delphi 7. ... Our application uses the bde to ... if we connect to this database with ado and select ...
      (borland.public.delphi.database.ado)
    • Re: ADO and BDE interact on XP SP2? - fixed
      ... Our application was failing when initialising the BDE with Windows XP SP2. ... initialisation before the application code really starts) before BDE ... I've found that removing the ADO components, ... > indirectly to connect to a database. ...
      (borland.public.delphi.database.ado)
    • Re: Is ADO Dead (3)?
      ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
      (comp.databases.ms-access)