tags:

views:

184

answers:

0
Q: 

Error- The SQLNCLI provider is not registered on the local machine.

I get the above error in one of my apps. However there is no reference to using the SQLNCLI provider. I know before the ConnectionString had "Provider=SQLNCLI".However now its changed to "Provider=SQLOLEDB" (using OLEDB since the same app connects to Access and SQL database). Why then do I still get the error?

related questions

Linked servers SQLNCLI problem. "No transaction is active"
difference between sql providers SQLOLEDB and SQLNCLI
Logon failed, Crystal Reports 9, VB6 , sql server, sqlncli
Changing SQL Provider from SQLOLEDB.1 to SQLNCLI.1 causes app to fail when accessing data via stored procedure
Upgrading to SQL Server 2005: Cannot INSERT QNAN into float column?
SQL Native Client crashes when second connection is opened when connection pooling is on?
SQL Native Client ODBC application not disconnecting after SQLDisconnect and not pooling?
sqlnclir.rll being loaded and unloaded continuously
Dead-lock issue created by 2 SQL connections, each using transactions, each working with a different table, with a foreign key constraint between the two tables
Need a row count after SELECT statement: what's the optimal SQL approach?
SQLBindParameter to prepare for SQLPutData using C++ and SQL Native Client
SQLGetData issues using C++ and SQL Native Client