Rails - May 2006 - [FATAL] failed to allocate memory

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060522/89ad2fd6/attachment.html

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.

On 22/05/06, Caiwangqin <jesse.cai@gmail.com>
wrote:
>
> 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
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
>
>