Yesterday, I was particularly depressed. I opened the SQL Server Enterprise Manager and right-click the table to return all rows. The "provided program not found, this program is not correctly installed" dialog box appears, after clicking confirm, no data is returned.
So I searched the internet and found that many people encountered this problem, but there was no effective solution. We recommend that you reinstall SQL Server and the system. After several hours of Baidu and Google, there was no effective solution!
To uninstall SQL Server, all related directories and registry keys are deleted according to the online method. Reinstall SQL Server and pray that it can work normally. After the installation, you may not be able to restart the system.
Log on to SQL Server Enterprise Management and click again to return all rows. the system crashes !!!!!!!
Run SFC/scannow and put the system disk. After running, the problem persists!
Download mdac2.8 again and install it. After installation, the problem persists!
Download mdac2.7 again and install it. After installation, the problem persists!
The patch and software installed in the past two days have been uninstalled, and the problem persists!
Crashed! Crashed! Crashed! Crashed! Crashed! Crashed!
Do you have to reinstall the system ??????
Today, I went to work and thought that if I couldn't find a solution, I had to reinstall the system. I had to pity hundreds of applications and development environments on my system .....
Suddenly, some people on the internet suggested registering C:/program files/common files/system/ole db/msdasql. dll again.
So I looked at this file and found that it is likely to be a problem with this file.
So:
Regsvr32 "C:/program files/common files/system/ole db/msdasql. dll"
Result:
Loadlibrary ("C:/program files/common files/system/ole db/msdasql. dll") failed-messages such as failure to load modules
. Dizzy !!!
Go to the directory and find the DLL.
As a result, I have tried it for countless times. Here, it's a whole process. It's still not good! I thought there was a problem with this file. I deleted it first, and immediately generated it again. I thought it was a virus. Then I checked the system log, this is a system protected file, which is protected by WFP.
If a file with the same name is copied to another machine for overwriting, the problem still cannot be solved.
In pain ..................
I suddenly thought, is it because the DLL referenced by this DLL is faulty? Because when loadlibrary calls the DLL, if this DLL references other DLL, the system will load these DLL, and any errors will occur.
Check which DLL is referenced by msdsql. dll. Then a DLL is searched in the system to see if the file exists. After a long wait, I found that a DLL was not found. That is, msdatl3.dll. Hopefully, haha!
Search for the file online and find it on Microsoft's website:
MDAC 2.8 (2.80.1022.3) file list| File Name | Version (x86) | Description |
| 12520437. cpx | SQL Server code page Converter | |
| 12520850. cpx | SQL Server code page Converter | |
| Adcjavas. inc | ADC/RDS Javascript file inclusion | |
| Adcvbs. inc | ADC/RDS VBScript File | |
| Adojavas. inc | Ado Javascript file inclusion | |
| Adovbs. inc | Ado VBScript File | |
| Cliconfg. dll | 2000.85.1022.0 | Client Configuration Utility |
| Cliconfg.exe | 2000.85.1022.0 | Client Configuration Utility |
| Cliconfg. rll | 2000.85.1022.0 | Client Configuration Utility |
| Dbmsgnet. dll | 2000.85.1022.0 | Net Library for Winsock |
| Dbmsrpcn. dll | 2000.85.1022.0 | RPC net Library |
| Dbnetlib. dll | 2000.85.1022.0 | Net DLL for Winsock |
| Dbnmpntw. dll | 2000.85.1022.0 | SQL client named pipe net DLL |
| Ds16gt. dll | 3.510.3711.0 | ODBC 16-bit Driver Installation universal conversion |
| Ds32gt. dll | 3.525.1022.0 | ODBC driver installation universal conversion |
| Expsrv. dll | 6.0.0.8540 | Expression Service |
| Handler. Reg | Install the registry key file of the default RDS processing program | |
| Handsafe. Reg | Registry key file that keeps RDS running with Security Processing | |
| Instcat. SQL | SQL Server SP directory update program | |
| Msadce. dll | 2.80.1022.0 | Ole db cursor Engine |
| Msadcer. dll | 2.80.1022.0 | Ole db cursor engine Resources |
| Msadcf. dll | 2.80.1022.0 | Remote Data Service Data Factory |
| Msadcfr. dll | 2.80.1022.0 | Remote Data Service Data factory Resources |
| Msadco. dll | 2.80.1022.0 | Remote Data Service Data Control |
| Msadcor. dll | 2.80.1022.0 | Remote Data Service Data Control Resource |
| Msadcs. dll | 2.80.1022.0 | Remote Data Service ISAPI Library |
| Msadds. dll | 2.80.1022.0 | Ole db data shape provider |
| Msaddsr. dll | 2.80.1022.0 | Ole db data shape provider Resources |
| Msader15.dll | 2.80.1022.0 | Ado Resources |
| Msado15.dll | 2.80.1022.0 | ADO |
| Msadow.tlb | 2.80.1022.0 | Ado 2.0 Type Library |
| Msado21.tlb | 2.80.1022.0 | Ado 2.1 Type Library |
| Msado25.tlb | 2.80.1022.0 | Ado 2.5 Type Library |
| Msado26.tlb | 2.80.1022.0 | Ado 2.6 Type Library |
| Msado27.tlb | 2.80.1022.0 | Ado 2.7 Type Library |
| Msadomd. dll | 2.80.1022.0 | ADO MD |
| Msador15.dll | 2.80.1022.0 | ADO |
| Msadox. dll | 2.80.1022.0 | Ado Extension |
| Msadrh15.dll | 2.80.1022.0 | Ado row set Helper Program |
| Mscpxl32.dll | 3.525.1022.0 | ODBC code page Converter |
| Msdadc. dll | 2.80.1022.0 | Ole db data conversion stubs |
| Msdaenum. dll | 2.80.1022.0 | Ole db root enumerative program stub |
| Msdaer. dll | 2.80.1022.0 | Ole db error set stubs |
| Msdamg9x. dll | 2.80.1022.3 | Migrate DLL in Win98 |
| Msdaora. dll | 2.80.1022.0 | Oracle ole db Provider |
| Msdaorar. dll | 2.80.1022.0 | Oracle ole db Provider Resources |
| Msdaosp. dll | 2.80.1022.0 | Simple ole db Provider |
| Msdaprsr. dll | 2.80.1022.0 | Ole db persistent service resources |
| Msdaprst. dll | 2.80.1022.0 | Ole db persistent Service |
| Msdaps. dll | 2.80.1022.0 | Ole db interface proxy/stub |
| Msdarem. dll | 2.80.1022.0 | Ole db remote provider |
| Msdaremr. dll | 2.80.1022.0 | Ole db remote program resource provision |
| Msdart. dll | 2.80.1022.0 | Ole db runtime routine |
| Msdasc. dll | 2.80.1022.0 | Ole db service component stubs |
| Msdasql. dll | 2.80.1022.0 | Ole db provider for ODBC drivers |
| Msdasqlr. dll | 2.80.1022.0 | Ole db Provider resources of ODBC drivers |
| Msdatl3.dll | 2.80.1022.0 | Ole db implementation support routine |
| Msdatsrc. TLB | 9.1.1022.0 | Data access-data source interface |
| Msdatt. dll | 2.80.1022.0 | Ole db temporary table service |
| Msdaurl. dll | 9.2.1022.0 | Ole db rootbinder stub |
| Msdfmap. dll | 2.80.1022.0 | Data factory processing program |
| Msjro. dll | 2.80.1022.0 | Jet and repeated object |
| Msjtes40.dll | 4.0.2927.8 | Jet expression Service |
| Msorc32r. dll | 2.575.1022.0 | Oracle ODBC driver Library |
| Msorcl32.dll | 2.575.1022.0 | Oracle ODBC driver |
| Msvcirt. dll | 6.0.8168.0 | (R) C ++ Runtime Library |
| Msvcrt. dll | 6.0.8397.0 | (R) C Runtime Library |
| Mswdat10.dll | 4.0.3829.2 | Jet sorting table |
| Mswstr10.dll | 4.0.3829.2 | Jet sorting Database |
| Msxactps. dll | 2.80.1022.0 | Ole db transaction proxy/stub |
| Msxml3.dll | 8.40.9419.0 | Msxml3 SP4 |
| Msxml3a. dll | 8.20.8730.1 | Msxml3 resource file |
| Msxml3r. dll | 8.20.8730.1 | Msxml3 resource file |
| Mtxdm. dll | 2.16.6.902.0 | MTS connection pool-ODBC driver Manager |
| Mtxoci. dll | 2.16.6.854.0 | MTS-Oracle OCI |
| Odbc16gt. dll | 3.510.3711.0 | ODBC 16-bit universal conversion |
| Odbc32.dll | 3.525.1022.0 | ODBC driver Manager |
| Odbc32gt. dll | 3.525.1022.0 | ODBC driver universal conversion |
| Odbcad32.exe | 3.525.1022.0 | ODBC Manager |
| Odbcbcp. dll | 2000.85.1022.0 | SQL Server ODBC driver BCP Library |
| Odbcconf. dll | 3.525.1022.0 | ODBC driver configuration program |
| Odbcconf.exe | 3.525.1022.0 | ODBC driver configuration program |
| Odbccp32.cpl | 3.525.1022.0 | ODBC Control Panel |
| Odbccp32.dll | 3.525.1022.0 | ODBC Installer |
| Odbccr32.dll | 3.525.1022.0 | ODBC cursor library |
| Odbccu32.dll | 3.525.1022.0 | ODBC cursor library |
| Odbcint. dll | 3.525.1022.0 | ODBC Resources |
| Odbctrac. dll | 3.525.1022.0 | ODBC driver manager tracking |
| Oledb32.dll | 2.80.1022.0 | Ole db core services |
| Oledb32a. dll | 2.80.1022.0 | ANSI resources of ole db core services |
| Oledb32r. dll | 2.80.1022.0 | Ole db core service resources |
| Oledbjvs. inc | Ole db JavaScript contains files | |
| Oledbvbs. inc | Ole db vbs files | |
| Psapi. dll | 4.0.1371.1 | Process status helper |
| Sqloledb. dll | 2000.85.1022.0 | Ole db provider of SQL Server |
| Sqloledb. rll | 2000.85.1022.0 | Ole db Provider resource library of SQL Server |
| Sqlsrv32.dll | 2000.85.1022.0 | SQL Server ODBC driver |
| Sqlsrv32.rll | 2000.85.1022.0 | SQL Server ODBC driver resource library |
| Sqlunirl. dll | 2000.80.728.0 | SQL Server Unicode resource layer Library |
| Sqlxmlx. dll | 2000.85.1022.0 | XML extension of SQL Server |
| Sqlxmlx. rll | 2000.85.1022.0 | XML extension resource library of SQL Server |
| Vbajet32.dll | 6.0.1.8268 | Expression service Loader |
This is really a key file in MDAC, so in the temporary directory after mdac2.8 decompression open all the CAB files to find the file, the strange thing is that did not find. My installation package is from Microsoft. That's right !!! Puzzled !!!
So I had to go
Http://www.dlldump.com/download-dll-files_new.php/dllfiles/M/msdatl3.dll/2.81.1117.0/download.html
The file is downloaded. Copy it to the C:/winnt/system32 directory and register it again:
Regsvr32 "C:/program files/common files/system/ole db/msdasql. dll"
Yeah !!! Done !!!!!!
Thanks God !!!!!!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
