You receive a "Command line option syntax error" error message when you install SQL Server 2000 SP3

Article translations Article translations
Article ID: 841487 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you install Microsoft SQL Server 2000 Service Pack 3 (SP3) on your computer, you may receive the following error message:
SQL Redist
content: Command line option syntax error. Type Command /? for Help.
If you click OK in the message box, the installation of SQL Server 2000 SP3 may complete successfully. However, the Sqlredist.exe program may not have run successfully during the installation of SQL Server 2000 SP3. This problem may occur if all the following conditions are true:
  • You run the SQL Server 2000 SP3 Setup.bat file from a folder that contains double-byte character set (DBCS) characters in the folder name.
  • An ODBC client program that uses the Sqlsrv32.dll file is running on your computer.
Additionally, if you install the MS03-033 security update for Microsoft Data Access Components (MDAC) on your computer after this problem occurs, the SQL Server Agent service may not start successfully, and you may receive the following error message:
Unable to load SQL Server ODBC driver resource DLL. The application cannot continue.

WORKAROUND

To work around this problem, run the SQL Server 2000 SP3 Setup.bat file from a folder that does not contain DBCS characters in the folder name.

MORE INFORMATION

When SQL Server 2000 SP3 is installed, the SQL Server 2000 SP3 installer replaces the existing MDAC files on the computer with the files for MDAC 2.7 SP1, even if the Sqlredist.exe program does not run successfully. However, the SQL Server 2000 SP3 installer does not update the
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\FullInstallVer
registry key with the correct version of MDAC.

If you install the MS03-033 security update after this problem occurs, the MS03-033 security update installer does not replace the Sqlsrv32.rll file because the installer does not recognize the version of MDAC that is installed on your computer. Therefore, the ODBC client application cannot load the correct version of resource file, and you receive the error message that is mentioned in the "Symptoms" section. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
823718 MS03-033: Security Update for Microsoft Data Access Components

Properties

Article ID: 841487 - Last Review: May 27, 2004 - Revision: 1.2
APPLIES TO
  • Microsoft SQL Server 2000 Service Pack 3
Keywords: 
kbsecurity kbsetup kbdriver kbprb KB841487

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com