解决WIN2003安装sqlserver2000失败的方法

2024-08-31 00:46:54

字体：大中小

来源：转载

供稿：网友

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"

上一篇：解读SQL语句经验技巧

下一篇：如何获取SqlServer2005数据库表结构