This article shares with you the solution to the ADODB.Connection error '800a0e7a' that occurs in Windows 2008R2 64-bit system. The method is very simple, but the processing process is very tortuous. I recommend it here to everyone, and friends in need can refer to it.
This problem does not exist under IIS6. When the system is put into Windows2008R2 64-bit system under IIS7.5, the ADODB.Connection error '800a0e7a' appears. The detailed solution is given below. It is actually very simple.
Copy the code code as follows:ADODB.Connection error '800a0e7a'
Provider not found. The program may not be installed correctly.
/hua1/manage/inc/conn.asp, line 8
At first glance, it seemed to be a database connection problem, but I repeatedly checked the database connection code and there was no error. Then I switched to my own machine to run the website, and the program ran normally. Therefore, I concluded that the website program was normal. The next issue to consider is the machine environment configuration. Is it a problem with the server software? This machine is equipped with IIS of win7. I carefully checked the IIS configuration and found no problem for the time being.
Bored and blindly clicking around, I found the problem:
Because the system is 64Bit win7, this problem will occur. The method is as follows:
Find the IIS application pool, click the corresponding application pool -> right-click and select Advanced Settings -> General -> Enable 32-bit applications and set it to True.
This way my problem is solved. .
The above is the entire content of this article, I hope you all like it.