RE: How to revert from MDAC 2.8 to 2.7?

Tech-Archive recommends: Fix windows errors by optimizing your registry



Well, I ran dasetup.exe /u on the machines that were on MDAC 2.8 RTM and it
reverted them to MDAC 2.5 SP3.
I ran our batch processing again, and all the machines went from 30 minutes
to 15 minutes to process, just like the machines that are running MDAC 2.7
SP1 REFRESH.

It looks like MS did something in MDAC 2.8 that really hosed SQL
connections, at least for Win2K Pro machines.

FYI, I did setup a new test machine which had WinXP Pro SP2 installed, and
had MDAC 2.8 RTM on it. That machine performed out batch process in 18
minutes. Much better than the Win2K/MDAC 2.8 combo, but not quite as good as
our Win2K MDAC 2.5 and Win2K MDAC 2.7 combos.

Looks like I foudn what was causing the slowdowns with our system.
I figured I would give a detailed reply here, in case anyone in the future
finds this post through a search.
.



Relevant Pages

  • Re: Delphi 7, TAdoConnection, Windows 2003 SP 1, MSDart.dll
    ... >> either a corrupted or incomplete or bad version of MDAC. ... >> The machines that I was dealing with happened to be xp machines which ... >> configuration and they had to do it. ... >>> Stefan Westner ...
    (borland.public.delphi.database.ado)
  • Re: How to revert from MDAC 2.8 to 2.7?
    ... That article, which point to the rollback, should work with MDAC 2.8 as ... > All of the machines are of identical hardware configurations, same OS, ... > And the MDAC install docs state that installing an older version will not ...
    (microsoft.public.data.ado)
  • Re: Access2000 to SQLServer2000 on an XP Nachine (sqlsrv32.dll)
    ... sqlsrv32.dll is part of MDAC. ... > I am having a problem connecting to my SQL server. ... A handful of Windows 2000 machines used to give ... > SQL Server Error: 0 ...
    (microsoft.public.data.odbc)
  • Re: MDAC
    ... before installing the latest version of MDAC it didn't connect and give ... this is the first time it is happening to me. ... are reluctant to install the latest version of MDAC in all the machines ...
    (comp.databases.ms-access)
  • Re: Failure to open database
    ... There were problems at the same place on Win9x machines ... >about a year ago & that is when I learned about the MDAC versions. ... Could the MDAC(of your customer's WinXP SP2 ... customer to refresh the MDAC: ...
    (microsoft.public.vc.database)