NoMemoryError: negative allocation size (or too big)

[Halt]

Got this error after selecting rows after establishing connection to another/non-default database in odbc.

ActiveRecord::StatementInvalid in BookingsController#index

NoMemoryError: negative allocation size (or too big): SELECT * FROM [Orders] 

Trace:

C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-2.3.5/lib/active_record/connection_adapters/sqlserver_adapter.rb:914:in `raw_select'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-2.3.5/lib/active_record/connection_adapters/sqlserver_adapter.rb:863:in `select'

[metaskills]

I'd have to see more code to understand the issue, including the class examples and connection methods, etc.

[Halt]

btw:
just test it on my linux(fedora) box and connect through FreeTDS and unixODBC and everything is ok.

hmmm. seems the problem with Microsoft ODBC driver...

[metaskills]

Good to know, but that info provides me no value for the ticket :)

[Halt]

hi GURUs!

so, still have problems with gettin data from two odbc:

i have two odbc dsn's in windows, configured on different databases.

here is my code:

database.yml

  login: &login
  adapter: sqlserver
  mode: odbc
  username: sa
  password: sapwd
  encoding: utf8
  host: 10.0.0.1

development:
  dsn: Data
  <<: *login

test:
  dsn: Data
  <<: *login

production:
  dsn: Data
  <<: *login

shop:
  dsn: Shop
  <<: *login

Models:

class Client < ActiveRecord::Base

end

class ShopBase < ActiveRecord::Base
    self.abstract_class = true
    establish_connection("shop")

end

class Order < ShopBase

end

There is no problem with selecting data from development database (dsn: Data),

@Clients = Client.all

but when i'm try to fetch Orders i'm receive this error.

@orders = Order.all

I test it on both x86 and x64 environments. Googling the problem has no results.

as i say before, in linux box (x64) with freeTDS and unixODBC everything works well.. but there is another problem with encodings.

plz help me, i'm stuck. :(

[metaskills]

OK, this does not sound adapter related, but more like a personal/project/rails/setup issue. I'll try to help tho :)

First you should know that I use this pattern in my day job app too, without issue. I suspect this is related to the ODBC/dsn setup in Windows. I'm not sure. I would suggest debuging

Order.connection
Order.table_name

And things like that. BTW, the "encoding: utf8" option is moot in SQL Server adapter.

[Halt]

Strange things happen. after truncate the table error has disappeared. Looks like the problem in the data.

I can close issue or better try to find what kind of data causes an error?

[metaskills]

I'll close it. Cheers :)