linked server error

  • Server: Msg 7399, Level 16, State 1, Line 1

    OLE DB provider 'OraOLEDB.Oracle' reported an error.

    [OLE/DB provider returned message: ]

    OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle' IRowset::GetData returned 0x80004005: ].

    I founded this error when linked with sql server 2000 to oracle 8 i through linked server ,

    its only fetched 100 and less then record

    but if i fetched more then 100 records then above error generate

    please help me

  • I keep on getting the same kind of error with HitOLEDB provider for AS/400. I had to refactor all my queries with four-part names into OPENQUERY to get rid of it. Doing this you'll also benefit from a great performance improvement, since you'll get data filtered on the remote side.

    I suggest trying to do the same query with four-part names and with OPENQUERY to see at least if you keep getting the same error.

    Hope this helps

    Gianluca

    -- Gianluca Sartori

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

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