The 'SQLNCLI' provider is not registered on the local machine, sql server 2012

sql sql-server sqlncli
tuj picture tuj · Sep 4, 2012 · Viewed 52.6k times · Source

Working on deploying an application from my development box to a client. On the client when I run my exe, I get the error "The 'SQLNCLI10' Provider is not registered on the local machine.

I'm developing in SQL Server 2012. I have tried installing sqlncli.msi on the target machine with no luck.

Can anyone tell me what package I need to install on the client machine to get my app to work? And if possible provide a URL to said package?

Thanks!

Answer

tuj picture tuj · Sep 4, 2012

Figured out I needed the 2008 version as opposed to the 2012 version.

http://go.microsoft.com/fwlink/?LinkId=123718&clcid=0x409

Related questions

Linked servers SQLNCLI problem. "No transaction is active"

Im trying to execute a stored procedure and simply insert its results in a temporary table, and I'm getting the following message: The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "MyServerName" was unable to …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More