解決WIN2003安裝sqlserver2000失敗的方法

2024-08-31 00:46:54

字體：大中小

供稿：網(wǎng)友

1、WIN2003需要打上sp1補(bǔ)丁。

2、注意數(shù)據(jù)執(zhí)行保護(hù)里的設(shè)置。右鍵點(diǎn)“我的電腦”——“屬性”——“高級(jí)”，“性能”框里的“設(shè)置”——“數(shù)據(jù)執(zhí)行保護(hù)”，需要選擇“僅為基本windows程序和服務(wù)啟用DEP（T）”。設(shè)置完成后，查看“系統(tǒng)ODBC”里面的“DSN”的數(shù)據(jù)源驅(qū)動(dòng)程序庫里是否有內(nèi)置的驅(qū)動(dòng)程序，有則可安裝。

3、修改注冊(cè)表：（以下為注冊(cè)表文件）

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語句經(jīng)驗(yàn)技巧

下一篇：如何獲取SqlServer2005數(shù)據(jù)庫表結(jié)構(gòu)