sqlserver_adapter

rubyonrails-core
1

There is a bug in the activerecord-sqlserver-adapter-2.2.21 gem. The error is in:

activerecord-sqlserver-adapter-2.2.21\lib\active_record \connection_adapters\sqlserver_adapter.rd

And is at line 1058.

FROM #{db_name}INFORMATION_SCHEMA.COLUMNS columns

should be

FROM #{db_name}.INFORMATION_SCHEMA.COLUMNS columns

If the period between the db_name and INFORMATION_SCHEMA is missed out, the database name gets appended to INFORMATION_SCHEMA. For example, if the database name is 'database_one', you will get an error:

Invalid object name 'database_oneINFORMATION_SCHEMA.COLUMNS' when you enter a connection.select.

2

The SQL Server adapter is not part of Rails Core. The project is here: http://github.com/rails-sqlserver/2000-2005-adapter

This bug looks familiar and there may have been a ticket or a current
one under progress. If not please open up a Github issues, issue, for
it.

  - Thanks,      Ken

3

You are right Ken. The issue is here:

http://github.com/rails-sqlserver/2000-2005-adapter/issues/closed/#issue/3

I've added my two pennies worth.

Thank you.

Rob