SQL Redist content: Command line option syntax error. Type C
有些 错误 的原因你真是做梦都想不到。 前两天我重装 SQL SERVER2000 ，结果在安装到数据库访问组件（ MDAC ）时出现了 错误 提示： SQL Redist content: Command line option syntax error. Type Command /? for Help. what is this? 以前从来没有出现过这
有些错误的原因你真是做梦都想不到。
前两天我重装SQL SERVER2000，结果在安装到数据库访问组件（MDAC）时出现了错误提示：
SQL Redist
content: Command line option syntax error. Type Command /? for Help.
what is this?以前从来没有出现过这样的情况啊。我也没放在心上，按下确定，继续安装。安装完成后，数据库可以启动，也可以附加新的数据库，似乎没有什么异常。但等到调试程序时问题就来了：程序连接不上数据库！奇怪，连接串还是那个连接串，数据库文件也还是那个数据库文件，什么都未改过，好好地，怎么忽然就连不上了呢？
看来是SQLSERVER没装好。又重装了几次，还是一模一样的错误。
什么原因呢？难道是近来在网上下载安装了一些软件，中毒了？还是由于装了某著名国产财务软件的缘故搞坏了注册表？因为装了这个财务软件后，我每次启动操作系统都会给我一个警告，查了系统事件，说是SQLSERVER的一个错误，不过并没有引起什么不便，所以一直置之不理。又或者是我为了节省系统资源，禁止了一些服务，从而引起不能正常安装与使用？……
分析了又分析，操作了又操作，问题还是摆在那里，仿佛一个挥之不去的噩梦。
没办法，只好使出最后一招了。我将错误提示信息放到网上进行搜索，寻寻觅觅，终于还是在微软站点找到答案。是这样说的：
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.
我英文很烂，不过还是勉强看明白了。其中第一点是说，如果你把安装文件放在一个拥有双字节的名字的文件夹里就活该倒大霉。我的SQL SERVER2000安装盘的所在文件夹起了个中文名字，而汉字正是所谓的双字节。将文件夹名字改回英文再装，问题解决了。
操作系统是简体中文的操作系统，SQL SERVER是简体中文的SQL SERVER，怎么将安装盘起了个简体中文的名字就不行了呢！
原文： http://www.webjx.com/htmldata/2005-07-22/1121982062.html
附注资源：sql server 2000安装出错解决方案 http://www.dahe.org/index.php/1/viewspace-697.html
MSSQL2000 安装过程中出现挂起的解决办法:
在运行窗口输入regedit，打开注册表编辑器，在HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control \Session Manager中找到PendingFileRenameOperations，删除该键值，关闭注册表编辑器。重新安装SQL Server 2000
MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AMMySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand
MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AMToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith
MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AMToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters
MySQL: String Data Types and ENUMs?May 13, 2025 am 12:05 AMMySQloffersechar, Varchar, text, Anddenumforstringdata.usecharforfixed-Lengthstrings, VarcharerForvariable-Length, text forlarger text, AndenumforenforcingdataAntegritywithaetofvalues.
MySQL BLOB: how to optimize BLOBs requestsMay 13, 2025 am 12:03 AMOptimizing MySQLBLOB requests can be done through the following strategies: 1. Reduce the frequency of BLOB query, use independent requests or delay loading; 2. Select the appropriate BLOB type (such as TINYBLOB); 3. Separate the BLOB data into separate tables; 4. Compress the BLOB data at the application layer; 5. Index the BLOB metadata. These methods can effectively improve performance by combining monitoring, caching and data sharding in actual applications.
Adding Users to MySQL: The Complete TutorialMay 12, 2025 am 12:14 AMMastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.
Mastering MySQL String Data Types: VARCHAR vs. TEXT vs. CHARMay 12, 2025 am 12:12 AMChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic
MySQL: String Data Types and Indexing: Best PracticesMay 12, 2025 am 12:11 AMBest practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
SublimeText3 English version
Recommended: Win version, supports code prompts!
SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.
Dreamweaver CS6
Visual web development tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Mac version
God-level code editing software (SublimeText3)
