linked server problems
From: Matt Tapia (mtapia_at_inbizservices.com)
Date: 06/01/04
- Next message: Hugo Kornelis: "Re: Purge old ROWS"
- Previous message: Rick: "Purge old ROWS"
- Next in thread: Matt Tapia: "Re: linked server problems"
- Reply: Matt Tapia: "Re: linked server problems"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Jun 2004 13:59:25 -0500
I do the following to link a server:
EXEC sp_addlinkedserver 'MainLinkedServer', 'SQLServer OLEDB Provider',
'SQLOLEDB', 'MATT', NULL, NULL, 'WEEK'
It says it links fine (no errors), but when I do a select on a table I know
exists
select distinct T1."Institution" c1 from 'MainLinkedServer'...myTable T1
I get the following error:
OLE DB provider 'MainLinkedServer'does not contain table 'myTable'. The
table either does not exist or the current user does not have permissions on
that table.
OLE DB error trace [Non-interface error: OLE DB provider does not contain
the table: ProviderName='MainLinkedServer', TableName='myTable'].
any ideas?
- Next message: Hugo Kornelis: "Re: Purge old ROWS"
- Previous message: Rick: "Purge old ROWS"
- Next in thread: Matt Tapia: "Re: linked server problems"
- Reply: Matt Tapia: "Re: linked server problems"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
