Microsoft KB Archive/285077

= PRB: SQL Server 7.0 Setup Fails When ODBC Components on Your System Need Updating =

Article ID: 285077

Article Last Modified on 4/25/2007

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition, when used with:
 * Microsoft Windows NT 4.0

-



This article was previously published under Q285077



SYMPTOMS
When you install SQL Server 7.0 the setup may fail with the following error message:

ODBC Components on your system need to be updated but one or more files are in use or are marked read-only. Please close all applications and retry. A reboot may be necessary in order to free the files.



CAUSE
This behavior occurs because:
 * Services or applications that use ODBC currently have files in use.

-or-


 * The ODBC components on the system are out of date.



WORKAROUND
To work around this behavior, use these steps:  Close any applications that utilize ODBC. Verify that only the following necessary services are running:  Alerter

 Computer Browser

 Event Log

 License Logging Service

</li> Messenger

</li> NetBIOS Helper

</li> Net Logon

</li> NT LM Security Support Provider

</li> Plug and Play

</li> Remote Procedure Call (RPC) Locator

</li> Remote Procedure Call (RPC) Service

</li> Remote Registry Service

</li> Server

</li> Spooler

</li> TCP/IP

</li> Workstation</li></ul>

NOTE: If any other services are started, they must be stopped before you install SQL Server (with the exception of those required by the hardware manufacturer) or the setup may fail.

</li> After you stop all the unnecessary services, install SQL Server. If you continue to receive the error message shown in the &quot;Symptoms&quot; section, proceed with the next step.</li> Install the Microsoft Data Access Components (MDAC) version that is provided with SQL Server 7.0 by navigating to the \x86\Other directory on your SQL Server 7.0 CD and execute the Mdac_type.exe file. For example: F:\x86\OTHER\mdac_typ.exe

For more information about MDAC or if you want to apply a later version of MDAC, see the following Web address at:

http://msdn2.microsoft.com/en-us/data/aa937730.aspx

</li> After the MDAC installation completes, restart the computer.</li> Stop all the services except those listed in step 2, and then install SQL Server.</li></ol>