# Sql Adapter reports out of memory

**URL:** <https://www.ruby-forum.com/t/sql-adapter-reports-out-of-memory/160684>\
**Category:** Rails\
**Created:** [February 18, 2009, 7:54pm UTC](https://www.ruby-forum.com/t/sql-adapter-reports-out-of-memory/160684 "2009-02-18T19:54:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rroman81](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/bc8723/32.png) [@rroman81](https://www.ruby-forum.com/u/rroman81)\
**Post date:** [February 18, 2009, 7:54pm UTC](https://www.ruby-forum.com/t/sql-adapter-reports-out-of-memory/160684/1 "2009-02-18T19:54:33Z")

</div>

I’ve set up freeTDS, unixODBC and got sql\_adapter gem for rails  
2.2.2. It’s on x64 CentOS 5.  
within the app a call to ActiveRecord object to inspect columns fails  
like this:  
ActiveRecord::StatementInvalid: NoMemoryError: failed to allocate  
memory:  
SELECT  
cols.COLUMN\_NAME as ColName,  
cols.COLUMN\_DEFAULT as DefaultValue,  
cols.NUMERIC\_SCALE as numeric\_scale,  
cols.NUMERIC\_PRECISION as numeric\_precision,  
cols.DATA\_TYPE as ColType,  
cols.IS\_NULLABLE As IsNullable,  
COL\_LENGTH(cols.TABLE\_NAME, cols.COLUMN\_NAME) as Length,  
COLUMNPROPERTY(OBJECT\_ID(cols.TABLE\_NAME),  
cols.COLUMN\_NAME, ‘IsIdentity’) as IsIdentity,  
cols.NUMERIC\_SCALE as Scale  
FROM INFORMATION\_SCHEMA.COLUMNS cols  
WHERE cols.TABLE\_NAME = ‘ams\_Lookup’

```
    from /home/rroman/workspace/sfr-ams-trunk/vendor/rails/

```

activerecord/lib/active\_record/connection\_adapters/abstract\_adapter.rb:  
147:in `log' from /home/rroman/workspace/sfr-ams-trunk/vendor/gems/ activerecord-sqlserver-adapter-1.0.0.9216/lib/active_record/ connection_adapters/sqlserver_adapter.rb:288:in`columns’  
from /home/rroman/workspace/sfr-ams-trunk/vendor/rails/  
activerecord/lib/active\_record/base.rb:1145:in `columns' from /home/rroman/workspace/sfr-ams-trunk/vendor/rails/ activerecord/lib/active_record/base.rb:1219:in`inspect’

the config looks like this:  
AMS\_DB\_CONFIG = {  
:adapter =\> “sqlserver”,  
:mode =\> “odbc”,  
:dsn =\> ‘dsn’,  
:user =\> ‘username’,  
:password=\> ‘pass’  
}

as far as i can tell i can run the above query using tsql and get a  
valid return statement