Board index » off-topic » BDE/ADO interaction on XP SP2
Paul Redstone
Delphi Developer |
BDE/ADO interaction on XP SP22004-08-30 09:56:48 PM off-topic11 Hi I've posted this in the ado group as well but as it concerns BDE and ADO I thought I'd post here. 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 |