Поставщик 'SQLNCLI' не регистрируется на локальной машине
Я сказал бы, что Объединение списка в Банде Четыре заказывает, и Шаблоны Fowler Предприятия Arhitecture дадут Вам 99% того, что необходимо было бы когда-либо знать.
2 ответа
Правильный поставщик для SQL Server 2008 - SQLNCLI10.1 .
Для SQL Server 2012 это будет SQLNCLI11 . (источник)
К сожалению, переход на 2008 год не повлек за собой изменений ...
Could it be a problem with x86/x64? If the workstation in question is x64, and you've installed the x64 version of the client, but the application you're trying to run is in the x86 space, you may need the x86 version of the client on that workstation as well. An x86 app will only check for an x86 version of the provider, and seeing none, will give an error like this one. The x64 version is probably smart enough to check for either version, though maybe you'd have the same situation.
This same thing happens with ODBC - x86 and x64 data sources aren't available to the other type of application - if you want something to be visible from both builds of applications, you'll need to create an ODBC source in each version's Admin tool.