I am new on Linked server technology. I am getting this error one of my
linked server.
OLE DB provider 'mdw' does not contain table
'"mdm_BMO_DATA"."dbo"."MDM_IBSO"'. The table either does not exist or the
current user does not have permissions on that table.
Both source and target server and database is working properly. Please advice?
thanks
FarrukhThis is my query
'Select Top 10 * from mdw.mdm_BMO_DATA.dbo.MDM_IBSO'
''OLE DB error trace [Non-interface error: OLE DB provider does not contain
the table: ProviderName='mdw', TableName='"mdm_BMO_DATA"."dbo"."MDM_IBSO"'].
Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'mdw' does not contain table
'"mdm_BMO_DATA"."dbo"."MDM_IBSO"'. The table either does not exist or the
current user does not have permissions on that table.''
"FARRUKH" wrote:
> I am new on Linked server technology. I am getting this error one of my
> linked server.
> OLE DB provider 'mdw' does not contain table
> '"mdm_BMO_DATA"."dbo"."MDM_IBSO"'. The table either does not exist or the
> current user does not have permissions on that table.
> Both source and target server and database is working properly. Please advice?
> thanks
> Farrukh
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment