SQL2000 installation failed, [ODBC Driver Manager] No data source found, see log file for more information(2010-09-13 17:38:18)
reproduced
Recently installed the database SQL server2000 when installed to the end of the time, to jump out of the "SQL2000 installation failed, [ODBC driver Manager] did not find the data source, more information please view the log file" prompt, a little sure to close, find a lot of online, tried a lot of can not solve, But Kung fu is not a conscientious, finally found a solution, in this share with you:
Specifically open the log file details as follows (specific location in C:\WINDOWS\system32 of an SQL text file):
Starting now?
Chinese_prc_ci_as
-m-q-t4022-t3659
Working with service?
Driver={sql server};server=lz01; Uid=sa; pwd=;d Atabase=master
[Microsoft] [ODBC Driver Manager] No data source found
Driver={sql server};server=lz01; Uid=sa; pwd=;d Atabase=master
[Microsoft] [ODBC Driver Manager] No data source found
Driver={sql server};server=lz01; Uid=sa; pwd=;d Atabase=master
[Microsoft] [ODBC Driver Manager] No data source found
SQL Server configuration?
###############################################################################
17:00:08 Process Exit Code: (-1)
17:01:41 Setup failed to configure the server. Refer to Server error logs and C:\WINDOWS\sqlstp.log for more information.
17:01:41 Action Cleanupinstall:
17:01:41 c:\docume~1\admini~1\locals~1\temp\sqlsetup\bin\scm.exe-silent 1-action 4-service SQLSERVERAGENT
17:01:41 Process Exit Code: (1060) The specified service is not installed.
17:01:41 c:\docume~1\admini~1\locals~1\temp\sqlsetup\bin\scm.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.
The specific solutions are as follows:
No matter where you create a text file, then open it, copy the following code, and then rename it to a. reg format file, the file name can be arbitrarily taken, and then double-click to run it, write the registry, it is OK.
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"
[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"
"SQLLevel" = "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 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_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"
This article from Csdn Blog, reproduced please indicate the source: http://blog.csdn.net/AYongSoft/archive/2010/01/29/5268005.aspx
SQLServer2000 installation failed, [ODBC Driver Manager] No data source found, details see log file sql2000 [MICROSOFT][ODBC Driver Manager] No data source found, see sqlstp.org, exit directly