Error while opening ASP page. 800a0e7a “Provider cannot be found. It may not be properly installed.”

Created:

2016-11-16 12:59:32 UTC

Modified:

2017-04-24 11:16:57 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error while opening ASP page. 800a0e7a “Provider cannot be found. It may not be properly installed.”

Applicable to:

  • Plesk 9.x and below for Windows

Symptoms

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.

Cause

MSSQL native client is changed for ADODB connection string.The old connection string contains the link to MSSQL native client like this

Provider=SQLNCLI

For example

connString="Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;"

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.

Resolution

Set the correct "Provider" field:

For example:

connString="Provider=SQLNCLI11;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;"

Otherwise ASP engine will not link to the native client libraries.Anyway the following connection string is devoided of this incompatibility issue.

Driver={SQLServer}

More datails on connection string settings can be found at http://msdn.microsoft.com/library/ms722656 .

Have more questions? Submit a request
Please sign in to leave a comment.