BiEmme
asked on
Problems with SQLNCLI connection string
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?
Screen-Shot-2015-05-15-at-11.28.25.png
However, while trying to connect to SQL with "Provider=SQLNCLI..." or "Provider=SQLNCLI11..." or "Provider="SQLNCLI11.0..."
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?
Screen-Shot-2015-05-15-at-11.28.25.png
ASKER
Hello.
Well, we have 2 servers:
1) web server (without SQLNCLI11 installed)
2) sql (with SQLNCLI11 installed)
Is it possible that we should install SQLNCLI11 to the webserver, too?
Well, we have 2 servers:
1) web server (without SQLNCLI11 installed)
2) sql (with SQLNCLI11 installed)
Is it possible that we should install SQLNCLI11 to the webserver, too?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Barry... yes indeed, it looks that was a problem.
We have SQLNCLI on SQL server only, and NOT on our WEB server.
Problem solved!
We have SQLNCLI on SQL server only, and NOT on our WEB server.
Problem solved!
Please do a search for sqlncli11.dll on your server.
In CMD prompt you can do
dir /s sqlncli11.dll
Let me know if this dll is found