sql server odbc: LInk Tables -- sql server odbc

LInk Tables

MMouse99
4/7/2005 12:23:02 AM

sql server odbc:

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

Re: LInk Tables

Sue Hoegemeier
4/7/2005 6:02:59 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"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.