Re: No OLE DB providers listed when creating a Linked Server

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 09:47:25 -0600

Thanks for posting back Grant. That's along the lines of what others
have reported and now I remember that oldedb32 was the primary
offender in other cases as well. Hopefully this will get addressed in
a knowledge base article.

-Sue

On Wed, 27 Oct 2004 08:27:06 -0700, Grant Yatabe
<GrantYatabe@discussions.microsoft.com> wrote:

>Sue,
>
>Thanks for the reply. That was the direction I was going in. The culprit
>dll was OLEDB32.dll - the core services dll for OLEDB. For some reason the
>date of the 2.71 version was later than the 2.8 version. There were also 3
>other dll's that were mismatchted. An additional note; reinstalling mdac 2.8
>does not fix the problem. You will have to manually change these dll's (not
>forgetting to place them in the dllcache folder). I only replaced the
>OLEDB32.dll as it was the only one causing problems - that we can see right
>now. I'm listing my findings here for others to use if they encounter this
>same problem:
>
>Filename: OLEDB32.DLL
>Old version/date: 2.71.9042.0 - 10/27/2003 built by Lab06_N(_sqlbld)
>New version/date: 2.80.1022.0 - 2/20/2003
>
>Filename: ODBCBCP.DLL
>Old version/date: 2000.085.1025.00 - 12/12/2003 built by (_sqlbld)
>New version/date: 2000.85.1022 - 2/20/2003
>
>Filename: SQLSRV32.DLL
>Old version/date: 2000.085.1025.00 - 11/18/2003 built by (_sqlbld)
>New version/date: 2000.85.1022 - 2/20/2003
>
>Filename: MSXML3.DLL
>Old version/date: 8.50.2162.0 - 09/22/2004
>New version/date: 8.40.9419.0- 7/17/2003
>
>Regards,
>
>Grant
>
>
>"Sue Hoegemeier" wrote:
>
>> I've seen others reporting the problem when upgrading to Win 2003. It
>> was generally due to one of the MDAC dlls not getting updated but the
>> others getting updated. You can try running the component check to
>> check your MDAC setup or try reinstalling whatever version of MDAC you
>> are suppose to be running. You can download MDAC versions and the
>> component checker from:
>> http://msdn.microsoft.com/data/mdac/default.aspx
>>
>> -Sue

Relevant Pages

  • Error 2147024769
    ... One installation out of hundreds returned this error and was unable to ... open the switchboard form, reporting ... Microsoft has a downloadable tool to check your MDAC ... and for our single problem workstation it reported MDAC 2.7 SP1 ...
    (microsoft.public.access.forms)
  • Re: No OLE DB providers listed when creating a Linked Server
    ... dll was OLEDB32.dll - the core services dll for OLEDB. ... An additional note; reinstalling mdac 2.8 ... > component checker from: ...
    (microsoft.public.sqlserver.security)
  • RE: Conection Error
    ... Try reinstalling MDAC, maybe something you ... Use the MDAC component checker to see if you ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.connect)