Am running sql server 2k and have a linked server to an
oracle database. Have created views in a sql server
database pointed at the Oracled database using the linked
server. Applications use the sql server database just
fine... sometimes for 20 to 30 days before I get error
message. "[Microsoft][ODBC SQL Server Driver][SQL Server]
[OLEDB provider returned message: Not enough storage is
available to complete this operation.]" There is plenty
of disk space and presumably memory. Is there some kind
of memory leak? Like I said, it might run for a month
without hanging.... then again, it may hang every day.
Tables in the database can still be accessed, but the
views fail.

Check which version of ADO you are running

http://support.microsoft.com/default...;en-us;Q182423

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"John" <john_bearse (AT) hotmail (DOT) com> wrote