Forum Discussion

brook_grewcock's avatar
brook_grewcock
Contributor
9 years ago
Solved

ADO.CreateADOCommand produces "Provider cannot be found. It may not be properly installed"

I am using ADO.CreateADOCommand to connect to a Microsoft SQL 2005 server, but keep getting the error message "Provider cannot be found. It may not be properly installed". This script still works on...
  • brook_grewcock's avatar
    brook_grewcock
    9 years ago

    Support came through. The issue is that where as before SQL Server Native Client 10 and 11 used to live together side by side, now when you install the Client 11 redistributable on either Windows8 or Windows10. It uninstalls any version of 10 you might have.

     

    So I had SQL Server Native Client 11 installed instead of 10, and had SQLNCLI10 specified in my connection string as the provider name. Changing this to SQLNCLI11 has fixed my issue.

     

    The lesson here is to see which native drivers you have installed, and check your connection string's provider name.