search for: ordinal_position

I am unable to get ActiveRecord session support to work under 2.x against a SQL Server database. I''m starting to wonder if anyone is running 2.x against SQL Server? Is anyone running under the following configuration: Rails 2.x SQL Server 2000 DB (using AR adapter in ODBC mode) AR store for ActionController session store. I''d like to chat with you if you are. Thanks, Wes --

...1 <NA> <NA> 8 NA 3 10 1 <NA> <NA> 4 NA 4 10 1 <NA> <NA> 4 NA 5 2 1 <NA> <NA> 8 NA CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE ORDINAL 1 510 1 YES 1 2 NA 2 YES 2 3 NA 3 YES 3 4 NA 4 YES 4 5 NA 5 Y...

...;) it returns [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME COLUMN_NAME DATA_TYPE [6] TYPE_NAME PRECISION LENGTH SCALE RADIX [11] NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB [16] CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE DISPLAY_SIZE FIELD_TYPE <0 rows> (or 0-length row.names) But there is no test table defined anywhere else but the X schema. If I do sqlSave(db,aDataFrame,"X.test",T,F), it says test already defined. If I change the aDataFrame to be different than the fiel...

...7 H41 dbo v_MAFiles UpdatedBy 12 varchar 60 60 NA 8 H41 dbo v_MAFiles UpdatedDateTime 93 datetime 23 16 3 NUM_PREC_RADIX NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB CHAR_OCTET_LENGTH ORDINAL_POSITION 1 NA 0 <NA> <NA> 1 NA 3 1 2 NA 0 <NA> <NA> -9 NA NA 2 3 NA 0 <NA> <NA> 9...