PRB: SQL Server 7.0 Setup Fails When ODBC Components on Your System Need Updating (285077)


The information in this article applies to:

  • Microsoft SQL Server 7.0, when used with:
    • the operating system: 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:
  1. Close any applications that utilize ODBC.
  2. Verify that only the following necessary services are running:
    • Alerter

    • Computer Browser

    • Event Log

    • License Logging Service

    • Messenger

    • NetBIOS Helper

    • Net Logon

    • NT LM Security Support Provider

    • Plug and Play

    • Remote Procedure Call (RPC) Locator

    • Remote Procedure Call (RPC) Service

    • Remote Registry Service

    • Server

    • Spooler

    • TCP/IP

    • Workstation


    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.

  3. After you stop all the unnecessary services, install SQL Server. If you continue to receive the error message shown in the "Symptoms" section, proceed with the next step.
  4. 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://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001860

  5. After the MDAC installation completes, restart the computer.
  6. Stop all the services except those listed in step 2, and then install SQL Server.

REFERENCES

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

192710 INF: Basic Guidelines for Installing SQL Server 6.5 or 7.0

Modification Type:MajorLast Reviewed:10/13/2003
Keywords:kbprb KB285077
©2003 Microsoft Corporation. All rights reserved.