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:incolumns’
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:ininspect’
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