解决WIN2003安装sqlserver2000失败_[SQL Server教程] 1、WIN2003需要打上sp1补丁。
2、注意数据执行保护里的设置。右键点“我的电脑”——“属性”——“高级”,“性能”框里的“设置”——“数据执行保护”,需要选择“仅为基本windows程序和服务启用DEP(T)”。设置完成后,查看“系统ODBC”里面的“DSN”的数据源驱动程序库里是否有内置的驱动程序,有则可安装。
3、修改注册表:(以下为注册表文件)
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"
|