SQLServer2000安装失败,[ODBC 驱动程序管理器]未发现数据源,详细信息请查看日志文件 sql2000 [Microsoft][ODBC 驱动程序管理器] 未发现数据源,参见sqlstp.org,直接退出

SQL2000安装失败,[ODBC 驱动程序管理器]未发现数据源,详细信息请查看日志文件

(2010-09-13 17:38:18)
 
 

最近安装数据库sql server2000时安装到要结束的时候,一下跳出"SQL2000安装失败,[ODBC 驱动程序管理器]未发现数据源,详细信息请查看日志文件"提示,一点确定就关闭,在网上找了好多,试了好多都不能解决,但是功夫不负有心人啊,最后终于找到了解决办法,在这跟大家分享下:

具体打开日志文件详细信息如下(具体位置在C:WINDOWSsystem32的一个sql文本文件):

正在启动?

Chinese_PRC_CI_AS

-m -Q -T4022 -T3659

正在与服务?

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

[Microsoft][ODBC 驱动程序管理器] 未发现数据源

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

[Microsoft][ODBC 驱动程序管理器] 未发现数据源

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

[Microsoft][ODBC 驱动程序管理器] 未发现数据源

SQL Server 配置?

###############################################################################

17:00:08 Process Exit Code: (-1)
17:01:41 安装程序配置服务器失败。参考服务器错误日志和 C:WINDOWSsqlstp.log 了解更多信息。
17:01:41 Action CleanUpInstall:
17:01:41 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 4 -Service SQLSERVERAGENT
17:01:41 Process Exit Code: (1060) 指定的服务未安装。

17:01:41 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 4 -Service MSSQLSERVER
17:01:41 Process Exit Code: (0)
17:01:41 StatsGenerate returned: 2
17:01:41 StatsGenerate (0x0,0x1,0xf00,0x100,2052,303,0x0,0x1,0,0,0
17:01:41 StatsGenerate -1,Administrator)
17:01:41 Installation Failed.

具体解决办法如下:

不管你在什么地方新建一个文本文件,然后打开它,把下面的代码复制进去,然后重命名成.reg的格式文件,文件名可以随便取,然后双击运行它,就写放注册表了,就OK了。

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINESOFTWAREODBC]

[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INI]

[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INILocalServer]
"Description"=""
"Server"="(Local)"
"Trusted_connection"=""
"UseProcForPrepare"="Yes"

[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INIODBC Data Sources]
"LocalServer"="SQL Server"
"TrioMotors"="Microsoft Access Driver (*.mdb)"

[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INIODBC File DSN]
"DefaultDSNDir"="C:\Program Files\Common Files\ODBC\Data Sources"


[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INITrioMotorsEngines]

[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INITrioMotorsEnginesJet]
"ImplicitCommitSync"="Yes"
"MaxBufferSize"=dword:00000200
"PageTimeout"=dword:00000005
"Threads"=dword:00000003
"UserCommitSync"="Yes"

[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INI]


[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIDriver 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_MACHINESOFTWAREODBCODBCINST.INIDriver 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_MACHINESOFTWAREODBCODBCINST.INIDriver 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_MACHINESOFTWAREODBCODBCINST.INIDriver 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_MACHINESOFTWAREODBCODBCINST.INIDriver 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_MACHINESOFTWAREODBCODBCINST.INIDriver 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMicrosoft 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_MACHINESOFTWAREODBCODBCINST.INIMS Code Page Translator]
"Translator"="C:\WINDOWS\system32\MSCPXL32.dll"
"Setup"="C:\WINDOWS\system32\MSCPXL32.dll"
"UsageCount"=dword:00000002


[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Core]
"UsageCount"=dword:00000002

[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC 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_MACHINESOFTWAREODBCODBCINST.INIODBC Translators]
"MS Code Page Translator"="Installed"

[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INISQL 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"


本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/AYongSoft/archive/2010/01/29/5268005.aspx

 
 
 
原文地址:https://www.cnblogs.com/lantianhf/p/5335686.html