[FATAL] failed to allocate memory


i used odbc connect ms sqlserver on windows, it raise : [FATAL] failed
allocate memory when “select top 10 * from tables”, the same app can run
correct on Debian, how can i fix the error?

Best Regards,

Mobile: +8613951787088
Tel: +86025-84818086 ext 233
Fax: +86025-84814993

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?


Dave M.