March 10, 2009 at 11:59 pm
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
March 11, 2009 at 1:59 am
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