Error while opening ASP page:
Error 800a0e7a "Provider cannot be found. It may not be properly installed."
The issue occurred after migration from source server with MSSQL Server 2008 to destination server with MSSQL Server 2012 installed.
MSSQL native client is changed for ADODB connection string.The old connection string contains the link to MSSQL native client like this
For the version 2012 of MSSQL native client is registered in the system using it's version number, so it is required to type the version of native client in the "Provider" field, i.e.
Set the correct "Provider" field:
Otherwise ASP engine will not link to the native client libraries.Anyway the following connection string is devoided of this incompatibility issue.
More datails on connection string settings can be found at http://msdn.microsoft.com/library/ms722656 .