Hi
Can anyone help me to accessing public synonym through linked server?
Linked server name : LS
For selecting table
select * from LS..user.tablename --> Its working
For selecting public synonym Synonym name : SYN
select * from openquery(LS, 'select * from SYN') -->Its working
I need to execute public synonym using four part selection. Any one help me....
select * from LS..username.SYN -->Throwing error [OLE DB provider 'MSDAORA' returned an invalid column definition.]
Instead of user[schema name]what i have to use for public synonym?
I tried with
select * from LS...SYN -->Throwing the same error as above [OLE DB provider 'MSDAORA' returned an invalid column definition.]