ADODB. Connection error ' 800a0e7a ' not found provider The program may not be installed correctly

Today, when the program was found, the error message is as follows:

ADODB. Connection error ' 800a0e7a '

The provider was not found. The program may not be installed correctly.

/conn.asp , line 6

This problem occurs because the system is a 64-bit Win7 or win8.1, and the workaround is as follows:

Locate the IIS application pool, set application pool default properties, general, enable 32-bit application, set to True.

This solves the problem.

Referenced from: http://www.mycodes.net/72/6470.htm

ADODB. Connection error ' 800a0e7a ' not found provider The program may not be installed correctly