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?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Barry CunneyCommented:
Hi BiEmme,
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
BiEmmeAuthor Commented:
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?
Barry CunneyCommented:
Hi BIEmme,
yes install this on the web server too because your ASP application will need to use this provider to do the connection to the database and it is the 64-bit version you need as your SQL Server is 64 bit

You should be able to download it or install it from your SQL Server installation CD.

I did a search on my system and it finds the dll in the following locations
  Directory of C:\Windows\System32

20/10/2012  00:26         3,480,048 sqlncli11.dll
               1 File(s)      3,480,048 bytes

 Directory of C:\Windows\SysWOW64

20/10/2012  00:16         3,004,912 sqlncli11.dll
               1 File(s)      3,004,912 bytes

     Total Files Listed:
               2 File(s)      6,484,960 bytes
               0 Dir(s)  254,993,973,248 bytes free

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BiEmmeAuthor Commented:
Barry... yes indeed, it looks that was a problem.
We have SQLNCLI on SQL server only, and NOT on our WEB server.

Problem solved!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.