Post reply

problem with linked server

  • June 30, 2004 at 1:35 am

    #83256

    Hi,

    I am new in administating SQL server 2000 . I have SQL server and Oracle, I made link name MONORA, my ORACLE user (shema) call JZOP and table is IZDVOJENA_OR.

    Now I am trying to execute one query

    select * from MONORA..JZOP.IZDVOJENA_OR

    and I got message:

    Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' reported an error. The provider did not give any information about the error. OLE DB error trace [OLE/DB Provider 'MSDAORA' IUnknown::QueryInterface returned 0x80004005: The provider did not give any information about the error.].

     

    When i wrote like this

    select * from MONORA...IZDVOJENA_OR

    it works OK

    What does it mean ...

    help

    thanks

     

     

  • July 1, 2004 at 3:41 am

    #512834

    Hi Ilijana,

    I am not familiar with omitting the database name but it seems that omitting the owner name enables the MS-data-access-oracle-unit  (I think this is that MSDAORA) to find the table you want where as using "JZOB" as owner cause this unit to access a non existing object. As far as there are only one table IZDVOJENA_OR the second form of you query is ok, isn't it?

    Karsten

     

  • July 1, 2004 at 4:39 am

    #512838

    Yes, but how can I solve my problem in documentation i found that i have to write name of oracle shema (owner of table)

    Why it doesn't work?

    thanks

    ilijana

  • July 1, 2004 at 7:00 am

    #512872

    I am using MSDASQL and an ODBC connection to access oracle. There I can use different owner specification to access different objects, but I have to put them into quotation marks. I am still thinking the way you specify the object owner prevents the MSDAORA to access the object you want. May be it's only missing quotation marks or something else in the way you have to specify it. Does your documentation say anything about that?

    Don't give up

    Karsten

  • July 7, 2004 at 4:21 pm

    #513758

    Will using OPENQUERY work?

    Something like:

    SELECT * FROM OPENQUERY(MONORA,'SELECT * FROM JZOP.IZDVOJENA_OR')

  • July 8, 2004 at 12:49 am

    #513794

    yes, it works

     

  • July 8, 2004 at 6:38 am

    #513833

    Ilijana,

    This is the Yukon adminstration forum. Yukon is the upcoming version of SQL Server (i.e. it hasn't been released yet) so this forum isn't very busy. Hence, you're more likely to get a quicker and better reply to your queries on the normal "Administration" forum.

    Regards

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

Viewing 7 posts - 1 through 6 (of 6 total)

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