hi
I have found a problem in link server
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: ].

but i have 10000 records in oracle database when i apply query in qury
analyzer
like
Select * From STXS..STXS0809.abc_CLIENT then above error genrate

but in

Select top 100 * From STXS..STXS0809.abc_CLIENT then 100 reocrds come
but i changed top 101 and above then error generate

please reply me

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...erver/200809/1

Maybe this one s.

http://support.microsoft.com/kb/822668



--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect


"lovekhan via SQLMonster.com" wrote:
> hi
> I have found a problem in link server
> 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: ].
>
> but i have 10000 records in oracle database when i apply query in qury
> analyzer
> like
> Select * From STXS..STXS0809.abc_CLIENT then above error genrate
>
> but in
>
> Select top 100 * From STXS..STXS0809.abc_CLIENT then 100 reocrds come
> but i changed top 101 and above then error generate
>
> please reply me
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums...erver/200809/1
>

I replied to this in .programming

"lovekhan via SQLMonster.com" <u45982@uwe> wrote in message
news:89c8546d89c75@uwe...
> hi
> I have found a problem in link server
> 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: ].
>
> but i have 10000 records in oracle database when i apply query in qury
> analyzer
> like
> Select * From STXS..STXS0809.abc_CLIENT then above error genrate
>
> but in
>
> Select top 100 * From STXS..STXS0809.abc_CLIENT then 100 reocrds come
> but i changed top 101 and above then error generate
>
> please reply me
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums...erver/200809/1
>