Rails - Feb 2009 - activerecord-odbc-adapter 2.0 failed to allocate memory

I''m currently trying to connect rails to a legacy SqlServer database.
System
is windows XP and my attempts to connect with activerecord sql adapter and
ADO.rb file failed miserably (I wrote a mail about it before)

So it seems like odbc adapter is more recent compared to sql adapter and
probably more used. I''m using active_record_store as session store, and
probably the first query going to server is to check the session id. But as
the query starts I get this error


Processing HomeController#home (for 127.0.0.1 at 2009-02-28 02:40:27) [GET]
  Session ID: 2da5690dbacb63cd80bf4c39d5eb014e
Rendering template within layouts/home_layout
Rendering home/home
Completed in 31ms (View: 15, DB: 0) | 200 OK [http://localhost/]
/!\ FAILSAFE /!\  Sat Feb 28 02:40:31 +0200 2009
  Status: 500 Internal Server Error
  failed to allocate memory

C:/ruby/lib/ruby/gems/1.8/gems/activerecord-odbc-adapter-2.0/lib/active_record/connection_adapters/odbc_adapter.rb:1532:in
`fetch_many''

C:/ruby/lib/ruby/gems/1.8/gems/activerecord-odbc-adapter-2.0/lib/active_record/connection_adapters/odbc_adapter.rb:1532:in
`select''

C:/ruby/lib/ruby/gems/1.8/gems/activerecord-odbc-adapter-2.0/lib/active_record/connection_adapters/odbc_adapter.rb:770:in
`select_all''

C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:635:in
`find_by_sql''

C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1490:in
`find_every''

C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1452:in
`find_initial''

C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:587:in
`find''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/session/active_record_store.rb:113:in
`find_by_session_id''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/session/active_record_store.rb:288:in
`initialize''

C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1398:in
`silence''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/session/active_record_store.rb:288:in
`initialize''
    C:/ruby/lib/ruby/1.8/cgi/session.rb:273:in `new''
    C:/ruby/lib/ruby/1.8/cgi/session.rb:273:in
`initialize_without_cgi_reader''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/cgi_ext/session.rb:19:in
`initialize''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/cgi_process.rb:94:in
`new''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/cgi_process.rb:94:in
`session''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/cgi_process.rb:130:in
`stale_session_check!''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/cgi_process.rb:78:in
`session''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:1205:in
`assign_shortcuts_without_flash''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/flash.rb:166:in
`assign_shortcuts''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:519:in
`process_without_filters''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/filters.rb:606:in
`process_without_session_management_support''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/session_management.rb:134:in
`process''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:392:in
`process''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:183:in
`handle_request''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:110:in
`dispatch_unlocked''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:123:in
`dispatch''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:122:in
`synchronize''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:122:in
`dispatch''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:132:in
`dispatch_cgi''

C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:39:in
`dispatch''
    C:/ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/webrick_server.rb:103:in
`handle_dispatch''
    C:/ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/webrick_server.rb:74:in
`service''
    C:/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service''
    C:/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run''
    C:/ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread''
    C:/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start''
    C:/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread''
    C:/ruby/lib/ruby/1.8/webrick/server.rb:95:in `start''
    C:/ruby/lib/ruby/1.8/webrick/server.rb:92:in `each''
    C:/ruby/lib/ruby/1.8/webrick/server.rb:92:in `start''
    C:/ruby/lib/ruby/1.8/webrick/server.rb:23:in `start''
    C:/ruby/lib/ruby/1.8/webrick/server.rb:82:in `start''
    C:/ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/webrick_server.rb:60:in
`dispatch''

C:/ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/commands/servers/webrick.rb:66
    C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`gem_original_require''
    C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`require''

C:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in
`require''

C:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:521:in
`new_constants_in''

C:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in
`require''
    C:/ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/commands/server.rb:49
    C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`gem_original_require''
    C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`require''
    script/server:3


I''m using

Rails 2.2.2
Activerecord-odbc-adapter 2.0 (1.5 needs an older version of Activerecord)
Sqlserver 2000 desktop edition (2005 express edition gave the same error
too)

Are there anyone using Rails on windows with SqlServer? Which path should I
follow?
Thx in advance

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---