Re: MDAC 2.1 and SQL Server 2000

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 06/27/04


Date: Sun, 27 Jun 2004 16:08:18 -0700

Yes. As I said, this version was one of the earliest versions of MDAC. It
was "very immature" code and had so many problems that the engineers at
Microsoft had to make some major changes and release 2.5 some time later.
The changes were so radical that the two versions caused any number of
compatibility issues. Yes, these apply to all versions of SQL Server. I
would not recommend it to any customer. Anyone still using it would be doing
so at their own risk.

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Phil" <phil_george@hotmail.com> wrote in message
news:8a5b16da.0406270217.608f6613@posting.google.com...
> But are there any issues specific to using it with SQL Server 2000,
> other than its inability to handle named instances?
>
>
> "William \(Bill\) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:<eY#H13tWEHA.3640@TK2MSFTNGP11.phx.gbl>...
> > MDAC 2.1 is fraught with problems. Memory leaks, and a bevy of other
issues.
> > Yes, there are "issues" galore.
> >
> > --


Relevant Pages

  • Re: MDAC 2.1 and SQL Server 2000
    ... Microsoft MVP ... "Phil" wrote in message ... I'm not allowed to upgrade the version of MDAC. ... > The database is running in SQL Server 2000 unfortunately. ...
    (microsoft.public.data.ado)
  • Re: Sql Server Agent (2000) erroring out on DTS Packages
    ... DTSRun: Package execution complete. ... and a problem with a missing MDAC dll. ... On Sql Server 7, this was SQLAgentCmdExec. ... Specified driver could not be loaded due to system error 126 (MERANT MSSS ...
    (microsoft.public.sqlserver.dts)
  • Re: Any help here???
    ... > start looking for things that are non standard (like having MDAC installed). ... > Format your drive, do a new/clean install of XP, and go from there. ... >>> data provider is optimized for SQL Server. ... >>> I've never had any SQL Server connectivity problems since I've switch to ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: SQL server Login connection failed sqlstate 28000 sql server e
    ... mdac 2.8 - ran the mdac checker and everything is fine ... and reconnect to the sql server using odbc - dsn connection. ... Now when we make mods to the database, reconnect, then we get that error. ... please download Component Checker from the link below to make sure ...
    (microsoft.public.sqlserver.odbc)
  • Re: Help Please Wit Error
    ... Occasionally I receive the error you are mentioning when the SQL Server ... I have had to completely remove the MDAC and re-install it as well ... see an example of the connection string you are using. ... Please install Microsoft Data Access Components ...
    (microsoft.public.dotnet.csharp.general)