Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
You receive a "Command line option syntax error" error message when you install SQL Server 2000 SP3
Article ID: 841487 - View products that this article applies to.
When you install Microsoft SQL Server 2000 Service Pack 3 (SP3) on your computer, you may receive the following error message:
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:
content: Command line option syntax error. Type Command /? for Help.
Unable to load SQL Server ODBC driver resource DLL. The application cannot continue.
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.
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\FullInstallVerregistry 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:
(http://support.microsoft.com/kb/823718/ )MS03-033: Security Update for Microsoft Data Access Components