Forum: Ruby on Rails activerecord-odbc-adapter 2.0 failed to allocate memory

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Seyit Caglar Abbasoglu (Guest)
on 2009-02-28 02:49
(Received via mailing list)
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
This topic is locked and can not be replied to.