An ASP database connection error occurs.

Yesterday, a customer called me and anxiously asked me to solve a problem. It turned out that a website I helped him four years ago suddenly had a problem. I connected the customer's website, an error was reported:

ADODB. Connection (0x800A0E7A)
No provider found. The program may not be correctly installed.

I have never encountered this problem. I Googled it and found that the solution to this problem was to upgrade mdac to 2.8 or above. I checked it and found that the customer had already upgraded to 2.8, another way is to convert sqloledb. dll re-registration, but it didn't work. Finally, a solution was found on Baidu, which turned out to be a permission problem. oldedb was under C: \ program files \ common files, check that the folder does not have the Users access permission. After you set the necessary permissions on the client machine, the problem is solved. But how can a sudden problem occur in a well-run program? I looked a little at the customer's machine. Dear user, the customer's security awareness was so bad that it was not known to have been installed as a private server for online games.

I wanted to help him deal with it, but considering that this customer has no business dealings with the company, I have already helped them a favor. Let him go, alas, people are getting lazy .......