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

From: Grant Yatabe (GrantYatabe_at_discussions.microsoft.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 08:27:06 -0700

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

  • Re: Cant Use Oledb functionality (missing System.Data.Oledb.dll)
    ... > I cannot use the Oledb functionality on my system because the ... How do I acquire this dll? ... It appears that you need to install the .Net framework. ... has nothing to do with .Net, but comes with the MDAC. ...
    (microsoft.public.data.oledb)
  • MDAC 2.7
    ... I recently upgraded from MDAC 2.6 to 2.7. ... I have an old VB6 dll that ... uses the data environment in some of the classes. ... This dll is ...
    (microsoft.public.sqlserver.programming)
  • Re: Microsoft dBase driver update (ODBC)
    ... It appears that you would only get the updated DLL if your Win2K SP4 system had ... MDAC 2.5 SP3 installed. ... and install the applicable update from MS06-014 in order to utilize ... Microsoft Security Bulletin MS06-014 ...
    (microsoft.public.win2000.general)
  • Re: Upgrade killed my connection, ASP to SQL doesnt work
    ... MDAC 2.8 installed, but every time I try to copy oledb32.dll to the ... It seems that if I can make a local copy of the DLL, ... same upgrade problem? ... > from a cleanly installed Windows 2003 Server. ...
    (microsoft.public.sqlserver.connect)
  • Re: Late Binding
    ... The code that uses ADO is necessary code. ... I have looked at the component checker. ... MDAC 2.1 - refers to ActiveX 2.1 ...
    (microsoft.public.access.queries)