hi, i used odbc connect ms sqlserver on windows, it raise : [FATAL] failed to allocate memory when "select top 10 * from tables", the same app can run correct on Debian, how can i fix the error? -- Best Regards, Caiwangqin http://www.uuzone.com Mobile: +8613951787088 Tel: +86025-84818086 ext 233 Fax: +86025-84814993
on 2006-05-22 11:46
on 2006-05-22 22:42
A few ideas: - your table name "tables" might be an issue; can you try changing it to something else? - a "select top 10 ..." query will consume a lot of memory; do you have enough memory (RAM and virtual) in your SQL Server box to run this request? - "select top 10 * ..." doesn't make it clear which criteria you're using to find the "top" records; I'm not sure how SQL Server would handle this. Is it possible to reword this query? Regards Dave M.