Re: Getting a "Microsoft OLE DB Provider for SQL Server" error mes

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bill Baker (BillBaker_at_discussions.microsoft.com)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 14:26:01 -0700

Thanks Ralph. I found a method for installing MDAC silently, and without
rebooting, so hopefully that will work.

Bill

"Ralph" wrote:

>
> "Bill Baker" <BillBaker@discussions.microsoft.com> wrote in message
> news:DBFF36DF-CB54-461E-A61D-0766049B500C@microsoft.com...
> > I was able to resolve this same issue by installing MDAC 2.8.
> Unfortunately
> > in my case, this is not a feasible option. We have many existing OS ghost
> > images that would need to be updated.
> >
> > Is there any way to update only the required files, instead of having to
> run
> > the entire MDAC installation?
> >
> > Thanks,
> > Bill
> >
>
> Warning this message is only half as sarcastic as it sounds. <g>
>
> You always have the ability to install/uninstall and mix 'n match data
> access components without installing the 'entire MDAC', however, once you go
> that route you are on your own. Expect surprises and very little support.
>
> The MDAC is designed to be installed one over the other - to provide what I
> loosely call a 'data-access stack'. Applications using earlier mdac
> components should work just fine after a newer mdac is installed. There are
> occasionally exceptions, but are rare and documented. Never lock a
> production environment to only one version of the MDAC. Assume there will be
> upgrades and that earlier MDACs may have to be installed. Don't half-step,
> don't get cute, and don't mix 'n match - unless there is absolutely no other
> way. Then think it over after you have slept on it. <g>
>
> -ralph
>
>
>

Relevant Pages

  • Re: Bug in Jet engine ?
    ... I would agree with Bill. ... >> installing anything it didn't, ... >> clean database), reinstalling latest MDAC and JET engine. ...
    (microsoft.public.data.ado)
  • Re: Getting a "Microsoft OLE DB Provider for SQL Server" error mes
    ... Thanks Ralph. ... I found a method for installing MDAC silently, ... Bill ...
    (microsoft.public.vb.enterprise)
  • Re: Getting strange MDAC Message
    ... is there a way to forcibly reinstall MDAC? ... > ODBC providers, and those providers link with the old MDAC. ... because installing MDAC should give you new providers. ... >> Robert W. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: MDAC
    ... Without knowing too many details you could try installing the latest version ... MDAC you'll see links to the different versions there. ... > updatimg Microsoft data Access Components 2.5 on your ...
    (microsoft.public.windowsxp.newusers)
  • Re: Windows Media Player 11 missing library?
    ... and tried to install WMP 11, ... MDAC 2.8 RTM ... MDAC 2.8 RTM is incompatible with this version of Windows. ... Let us know if downloading and installing that package is successful - ...
    (microsoft.public.windowsmedia.player)