Re: LInk Tables

From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
Date: Thu, 07 Apr 2005 06:02:59 -0600

To reference a table in a linked server, you need to use
LinkedServer.CatalogOrDatabase.SchemaOrOwner.Object
Try:
select *
from rubicon...qc_raw_mat_cat

-Sue

On Thu, 7 Apr 2005 00:23:02 -0700, "MMouse99"
<MMouse99@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Hi,
>
>I have created a link server within my enterprise. I can see the
>server - which is on a c-isam db - and all the the tables.
>
>What I am unable to do is query any of the tables.
>
>Link Server = Rubicon
>Table Name = qc_raw_mat_cat.
>
>select * from rubicon..qc_raw_mat_cat
>
>What have I missed / messed up?
>
>Many thanks
>
>
>example
>
>select * from rubicon..qc_raw_mat_cat

.

References:
- LInk Tables
  - From: MMouse99

Prev by Date: Re: "Provider not found" error
Next by Date: How to improve CPU Time
Previous by thread: LInk Tables
Next by thread: Re: "Provider not found" error
Index(es):
- Date
- Thread

Relevant Pages

RE: URGENT: error 2812
... Although it is not needed have you tried including dbo as the owner? ... It could be the linked server is not correctly configurered or permissions ... > of stored procedures on the link server and when I attempt ... > to execute those stored procedures (e.g. EXEC ...
(microsoft.public.sqlserver.programming)
RE: URGENT: error 2812
... Although it is not needed have you tried including dbo as the owner? ... It could be the linked server is not correctly configurered or permissions ... > of stored procedures on the link server and when I attempt ... > to execute those stored procedures (e.g. EXEC ...
(microsoft.public.sqlserver.server)
LInk Tables
... I have created a link server within my enterprise. ... server - which is on a c-isam db - and all the the tables. ... Prev by Date: ...
(microsoft.public.sqlserver.odbc)