Re: Remote Client for SQL Server 2000 - create linked servers

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

arno (aschobspam@xxxxxxxxx) writes:
I went through MS-KB 232060 which told to check dll usage with
ListDLLs.exe, no thread should use some dlls during mdac installation,
however, winlogon and explorer always use as far as I remember
odbc32.dll. (somebody should tell them...) BTW mdac 2.6 is aware of
newer versions and does not replace newer files.

I used MS cc_x86.msi (MS mdac component checker) and did not get a
"simple" info from it as it found many, many different versions of
MDAC-files on the PC. And replacing dlls is not possible because of
windows xp security features.

I found another tool calles mdac-repair.exe, links for both downloads:
http://www.macropool.com/en/download/repair_mdac.html

This tool found missing entries in the registry of quite a number of
files and added everthing to the registry.

Then the setup of SQL Server 2000 Client tools, esp. MDAC procedure
worked. I'd guess that the installation of mdac 2.6 failed because
there where many errors in the registry and it could not determine
which mdac version was installed (2.8 was installed, one normal
version, one from Windows 2003 server an some older versions).

Glad to hear that it finally worked out. There were a bunch of
things you mentioned, I have little clue of. I'm glad that I have
not encountered those problems myself!


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: No SQL OLE DB connectivity
    ... Renaming the dlls (they're in System32, ... but Windows file protection will keep overwriting...you can install MDAC 2.8 ... >>> been able to get MS Access to connect with the MS SQL Server at all. ... > I've tried multiple times to reload MDAC 2.8 to no avail. ...
    (microsoft.public.data.oledb)
  • Re: Remote Client for SQL Server 2000 - create linked servers
    ... ListDLLs.exe, no thread should use some dlls during mdac installation, ... Studio 4.5 additionally and do not have to install SQL Server Express ...
    (microsoft.public.sqlserver.clients)
  • Re: fail to installation of MDAC on SQL Server install
    ... If you update MDAC to the most recent version manually, SQL Server can skip ... > 11:25:20 Setup is installing Microsoft Data Access ... > 11:27:37 Installation of the Microsoft Data Access ...
    (microsoft.public.sqlserver.server)
  • MDAC installation problem (Version 2.53.6200.0 was found currently installed)
    ... I have got a server in W2K SP4 I need to have MDAC version 2.6 or above ... to have OLEDB working properly with SQL Server. ... component checker kepps telling me that MDAC 2.53 installed. ... installation have been done with a user profile belonging to the ...
    (microsoft.public.sqlserver.odbc)
  • Re: Connection no longer works
    ... Have you run component checker to verify your MDAC ... >I was able to connect to a SQL Server 2000 instance using ODBC on a Windows ...
    (microsoft.public.sqlserver.clients)