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