question

gbharathi avatar image
gbharathi asked

The OLE DB provider "sqlncl1" has not been registered.

EXECUTE sp_addlinkedserver @server = N'LSNorthwind', @srvproduct=N'LSNorthwind', @provider=N'sqlncl1', @datasrc=N'bharathi', @location=' ', @provstr=N'datasource-bharathi', @catalog=N'northwind'; when i execute the below query SELECT * FROM OPENQUERY (LSNorthwind, 'select * from dbo.Categories') it raises the error like sqlncl1 has not registered. i refer this info through the below link [ http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/][1] i need explanation and detailed examples of linked server 2008r2 and the terms provider,datasource,location etc give clarification for tat also [1]: http://
linked
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
shouldn't it be `sqlncli1`?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.