Working with 32-BIT ODBC drivers in 64 bit O/S classic ASP

ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.

Working with 64-bit Systems

Unfortunately there are no 64-bit ODBC drivers, so on 64-bit systems you will have to run your applications in 32-bit mode. To do so, use the following steps:

1. On the taskbar, click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
2. In the Connections pane, click Application Pools.
3. Highlight the application pool for your application, then click Advanced Settings... in the Actions pane.
4. In the Advanced Settings dialog, specify True for Enable 32-Bit Applications.
5. Click OK to close the Advanced Settings dialog.