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

Source: Internet
Author: User
Tags dbase driver manager odbc

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.