We have link servers on our database.  We are getting the following
error on SQL 7 query analyzer.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAM' reported an error. The provider ran out of
memory.

---

Request for Question Clarification by hammer-ga on 30 Oct 2002 05:13 PST

Is your linked server an Oracle server?

---

Clarification of Question by mayyang2000-ga on 31 Oct 2002 09:13 PST

No, all servers are MS SQL server 7.0.  Thanks

---

Request for Question Clarification by pwizard-ga on 31 Oct 2002 09:22 PST

Can you see if the following TechNet article provides any assistance?

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q198520&

-PWizard

---

Clarification of Question by mayyang2000-ga on 01 Nov 2002 06:58 PST

No, I read that article before and it is not in our case.  We don't
get "OLE DB provider 'STREAM' reported an error. The provider ran out
of memory." all the time, most time happen when our server was busy.