MS SQL Server ODBC - LInk Tables

Author

LInk Tables

MMouse99

2005-04-07, 7:01 am

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

Sue Hoegemeier

2005-04-07, 7:01 am

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@discussions
.microsoft.com> 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

Sponsored Links