I have a fresh install of Windows Server 2008 r2 which has IIS installed as the only role. I copied over some web pages and noticed when the web page uses an sql connection, everything works great. But, when it uses an access connection, it provides the following error:
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
The code for the connection uses oledb 12.0, and works fine on a server 2003 iis 6.0 machine.
So, i went to ODBC connections on my server, and there are no options under system or user. I then installed office 2007 and still no luck.
How do I get my odbc options to show up under the odbc in administrative tools?