We have VC++ / ODBC / Desktop SQL Server 7.0. Our program runs 9 select queries from the front-end thro' ODBC. If we set the min memory to 0 MB or 16 MB (use dynamic configuration of SQL Enterprise Manager in a 64 MB Ram machine) the program fails with the above error. "A time out occurred while waiting for memory resources to execute the query. Re-run the query".

If we set the min memory to 20MB and above, the program works fine. The result set is approx 90000 rows. In another 128 MB RAM machine a bigger query runs only at 128 MB min memory setting. Any other setting fails. Our worry is the more the result set should we keep changing the min memory setting. Does dynamic config of memory ever work ? We have played enough with the parameters of query wait time (s), mim memory per query, SQL timeout etc...

The same query works fine thro' query analyser and also in a client / server mode. It repeatedly fails in a SQL server desktop environment. Is this problem with C++ (or) ODBC (or) SQL Server.

PLEASE HELP !!!

Thanks
Gopal