Post reply

Linked server Execution Error

  • April 7, 2008 at 3:17 am

    #188709

    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.]

  • April 11, 2008 at 3:37 pm

    #801735

    are you working in the GUI (Management Studio) or through an application (like something built in Visual Studio)? Many, most, almost ALL of my problems went away when I quit using Management Studio.

    That was from a tip given to me by someone here.

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply