2、把Microsoft SQL Server文件夹整个删掉。
3、运行注册表,删除如下项:
HKEY_CURRENT_USER\\Software\\Microsoft\\Microsoft SQL Server
HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft SQL Server
HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\MSSQLServer
或者使用编辑-查找,输入 sql server项,然后搜索,重新搜索,揿F3
4、重新启动系统
5. 复制以下内容,保存成为*.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 )]
"Usage
Count"=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"
"SQLL
evel"="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 Drver"="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"
6. 重新安装sql server2000 个人版,XP系统中只可以安装个人版!下载本文