Could not locate registry entry for OLE DB provider 'LTF11'.

[garethn]

Three servers - I want to be able to create a view on server A from two tables on Servers B and C.
I have tried the following but received this error.

Server: Msg 7403, Level 16, State 1, Line 1
Could not locate registry entry for OLE DB provider 'LTF11'.


sp_addlinkedserver 'xxx','','LTF11'

select * from xxx.shopfloordatacapture.dbo.tblproducts

sp_addlinkedserver [ @server = ] 'server'
[ , [ @srvproduct = ] 'product_name' ]
[ , [ @provider = ] 'provider_name' ]
[ , [ @datasrc = ] 'data_source' ]
[ , [ @location = ] 'location' ]
[ , [ @provstr = ] 'provider_string' ]
[ , [ @catalog = ] 'catalog' ]

 

[tlbroadbent]

I've never heard of LTF11 data provider. What is the database used on the remote servers? If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[garethn]

LTF11 was the name of the server I was trying to connect to.
i just need to know how to link two servers.
need two fields from different dbases on diff servers

 

[JamesLean]

You pasted the information from BOL but didn't seem to read it yourself! ;-)

You need to specify the server name first, then the provider:

EXEC sp_addlinkedserver 'LTF11', 'SQL Server'

--James