Your syntax will always give an error.

Use,

select * from SHIBU.MASTER.DBO.TEST

John
www.ideo.com


-----Original Message-----
From: Shibu MB [mailto:[Email Address Removed] November 25, 2002 9:38 PM
To: LazyDBA.com Discussion
Subject: linked server errors ..


Hi all

I created a link server "shibu" to connect to a remote sqlserver from a
local sqlserver and i can see the remote tables in enterprise manager but
when i tried to access it from query analyzer i am getting an errror .I doubt
that the query which i gave is wrong .Please help me to solve this ..


select * from "SHIBU.MASTER.DBO.TEST"

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'SHIBU.MASTER.DBO.TEST'.




When i tried to access oracle tables using a link server i am getting a
different error . How can i solve this.??


Error 7399: OLE DB provider 'MSDAORA' reported an error.



Thanks
Shibu







MS Sql Server LazyDBA home page