May 15, 2015 at 2:48 am
We have fresh installation of SQL Server 2012 on WIN2012 64 bit. According to ODBC Administrator, SQL Server native Client 11.0 is installed, too.
However, while trying to connect to SQL with "Provider=SQLNCLI..." or "Provider=SQLNCLI11..." or "Provider="SQLNCLI11.0...", we receive an error:
ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed.
Our webpage is in classic ASP, app.pool enable 32-bit applictions is True, Managed pipeline is Classic.
Interesting, while we try to connect to the same SQL with OLEDB, t.i. "Provider=SQLOLEDB..." everything works just fine.
Any ideas?
May 15, 2015 at 3:01 am
have you tried this ?
http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-80040200/80040514/800a0e7a-errors.html
WINNERS NEVER QUIT AND QUITTERS NEVER WIN
sqlserversdba.wordpress.com
May 15, 2015 at 3:07 am
Yes, I went through this... all drivers are installed.
When I check ODBC Administrator, we have "SQL Server Native Client 11.0 (SQLNCLI11.dll).
May 15, 2015 at 5:44 am
Problem solved:
We have SQLNCLI on SQL server only, and NOT on our WEB server, which wants to connect to SQL.
After we installed SQLNCLI on our WEBSERVER, connection succeeded.
May 15, 2015 at 6:27 am
:cool::hehe:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply