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!

1

5 Answers

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

2

Are you perhaps working on a 64 bit machine and used the 32-bit install?

Here's the 64-bit link:

0

Use SQLNCLI11 for connecting to SQLserver 2012

eg:

Provider=SQLNCLI11;Data Source=trv6s177;Integrated Security=SSPI;Initial Catalog=DPVCube_Stage

Downloads

X86 Package (sqlncli.msi)

X64 Package (sqlncli.msi)

1

Some updates:

SQLNCLI11 works on windows 10 as well, and it can connect SQL 2012 and 2014 (not tested on later SQL versions) This is the latest version available

At the time of writing, the most updated package can be found here: SQL Server® 2012 Native Client - QFE

From Microsoft:

It is not recommended to use this driver for new development. The new OLE DB provider is called the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features going forward.

Article:

Download link:

Install the sqlncli10 provider on your machine.

The sqlncli10 provider for SQL 2008 R2 can be downloaded from here.

X86 package. X64 package

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.