try to increase the commandtimeout property to longer time.

-----Original Message-----
From: Brett Arthur [mailto:brett@q...]
Sent: Friday, September 14, 2001 3:05 AM
To: professional vb
Subject: [pro_vb] Microsoft OLE DB Provider for SQL Server error


Hi All,

I have business objects that are accessed via .asp pages (a set of dll's). 
The application has been designed as an interface between 2 systems, an 
accounting package running on windows & a web app running out of a unix 
environment. We use linked servers (2 SQL Server 7.0 databases, sp3) on 
the back end - one for our data & the other is used by the accounting app. 
All access into the databases is through sp's.

Users may perform updates & searches. Under load the following error is 
generated:

'2147217900 - Microsoft OLE DB Provider for SQL Server, A time out 
occurred while waiting for memory resources to execute the query. Rerun 
the query'

Anybody got any suggestions?

Thanks
Brett