安裝SQL Server 2000遇到的兩個問題及解決辦法

廢話一句都不說。直接談問題。本人在自己的機器上安裝SQL Server 2000時遇到了兩個問題。

1、安裝時出現兩個對話方塊：

一個標題為redlist內容為command line option syntax error,type command /? forhelp；

一個標題為html help 1.32 update內容為command line option syntax error,type command /? forhelp。

2、點擊“確定”後可以繼續安裝，但到最後時出現一個對話方塊，內容為“安裝程式設定管理員失敗...，參見C:/WINDOWS/sqlstp.log”，找到該檔案，在最後發現有以下內容

driver={sql server};server=PALADIN;UID=sa;PWD=;database=master

[Microsoft][ODBC 驅動程式管理器] 未探索資料源

driver={sql server};server=PALADIN;UID=sa;PWD=;database=master

[Microsoft][ODBC 驅動程式管理器] 未探索資料源

driver={sql server};server=PALADIN;UID=sa;PWD=;database=master

[Microsoft][ODBC 驅動程式管理器] 未探索資料源

SQL Server 配置?

解決辦法：

1、第一個問題是因為Sql Server的原安裝檔案所在路徑中有中文，將原安裝檔案移至純英文路徑下，然後

再安裝，就不會再出現那兩個對話方塊；

2、第二個問題是因為在註冊表刪除了HKEY_LOCAL_MACHINE/SOFTWARE/ODBC中有關sql sever的內容。

對其進行修複即可解決問題。修複辦法有二：

A、拷貝以下內容成一個.reg檔案，運行之後就可以成功安裝了；

－－－－－－－－－－－－－－－－－－－－－－－－－－－－

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC]

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI]

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/LocalServer]
"Description"=""
"Server"="(Local)"
"Trusted_connection"=""
"UseProcForPrepare"="Yes"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/ODBC Data Sources]
"LocalServer"="SQL Server"
"TrioMotors"="Microsoft Access Driver (*.mdb)"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/ODBC File DSN]
"DefaultDSNDir"="C://Program Files//Common Files//ODBC//Data Sources"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/TrioMotors/Engines]

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/TrioMotors/Engines/Jet]
"ImplicitCommitSync"="Yes"
"MaxBufferSize"=dword:00000200
"PageTimeout"=dword:00000005
"Threads"=dword:00000003
"UserCommitSync"="Yes"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI]

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Driver da Microsoft para arquivos texto (*.txt; *.csv)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odtext32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Driver do Microsoft Access (*.mdb)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odbcjt32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Driver do Microsoft dBase (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//oddbse32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Driver do Microsoft Excel(*.xls)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odexl32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.xls"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Driver do Microsoft Paradox (*.db )]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odpdx32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.db"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Driver para o Microsoft Visual FoxPro]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//vfpodbc.dll"
"Setup"="C://WINDOWS//system32//vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Access Driver (*.mdb)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odbcjt32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Access-Treiber (*.mdb)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odbcjt32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft dBase Driver (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//oddbse32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft dBase VFP Driver (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//vfpodbc.dll"
"Setup"="C://WINDOWS//system32//vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft dBase-Treiber (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//oddbse32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Excel Driver (*.xls)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odexl32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.xls"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Excel-Treiber (*.xls)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odexl32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.xls"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft FoxPro VFP Driver (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//vfpodbc.dll"
"Setup"="C://WINDOWS//system32//vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft ODBC for Oracle]
"UsageCount"=dword:00000001
"Driver"="C://WINDOWS//system32//msorcl32.dll"
"Setup"="C://WINDOWS//system32//msorcl32.dll"
"SQLLevel"="1"
"FileUsage"="0"
"DriverODBCVer"="02.50"
"ConnectFunctions"="YYY"
"APILevel"="1"
"CpTimeout"="120"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Paradox Driver (*.db )]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odpdx32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.db"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Paradox-Treiber (*.db )]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odpdx32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.db"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Text Driver (*.txt; *.csv)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odtext32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Text-Treiber (*.txt; *.csv)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odtext32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Visual FoxPro Driver]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//vfpodbc.dll"
"Setup"="C://WINDOWS//system32//vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Visual FoxPro-Treiber]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//vfpodbc.dll"
"Setup"="C://WINDOWS//system32//vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/MS Code Page Translator]
"Translator"="C://WINDOWS//system32//MSCPXL32.dll"
"Setup"="C://WINDOWS//system32//MSCPXL32.dll"
"UsageCount"=dword:00000002

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/ODBC Core]
"UsageCount"=dword:00000002

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/ODBC Drivers]
"SQL Server"="Installed"
"Microsoft Access Driver (*.mdb)"="Installed"
"Microsoft Text Driver (*.txt; *.csv)"="Installed"
"Microsoft Excel Driver (*.xls)"="Installed"
"Microsoft dBase Driver (*.dbf)"="Installed"
"Microsoft Paradox Driver (*.db )"="Installed"
"Microsoft Visual FoxPro Driver"="Installed"
"Microsoft FoxPro VFP Driver (*.dbf)"="Installed"
"Microsoft dBase VFP Driver (*.dbf)"="Installed"
"Microsoft Access-Treiber (*.mdb)"="Installed"
"Microsoft Text-Treiber (*.txt; *.csv)"="Installed"
"Microsoft Excel-Treiber (*.xls)"="Installed"
"Microsoft dBase-Treiber (*.dbf)"="Installed"
"Microsoft Paradox-Treiber (*.db )"="Installed"
"Microsoft Visual FoxPro-Treiber"="Installed"
"Driver do Microsoft Access (*.mdb)"="Installed"
"Driver da Microsoft para arquivos texto (*.txt; *.csv)"="Installed"
"Driver do Microsoft Excel(*.xls)"="Installed"
"Driver do Microsoft dBase (*.dbf)"="Installed"
"Driver do Microsoft Paradox (*.db )"="Installed"
"Driver para o Microsoft Visual FoxPro"="Installed"
"Microsoft ODBC for Oracle"="Installed"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/ODBC Translators]
"MS Code Page Translator"="Installed"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/SQL Server]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//SQLSRV32.dll"
"Setup"="C://WINDOWS//system32//sqlsrv32.dll"
"SQLLevel"="1"
"FileUsage"="0"
"DriverODBCVer"="03.50"
"ConnectFunctions"="YYY"
"APILevel"="2"
"CPTimeout"="60"

B、安裝ODBC修複工具，工具名稱為MDAC_TYP.EXE。大家到網上下載即可。下載完修複ODBC，即可

繼續成功安裝了。