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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---