I am porting a Rails app that is made up of 2 rails projects to SQL
Server. The app already runs with MySQL and Oracle. One Rails project is
the UI with a database that contains user/project specific data. The
second Rails project is the database server for the main data. The UI
makes REST calls to the database to get data to display. There is a list
of product lines that is used on a search screen so the user chooses
which product line to search. My problem is that with SQL Server as the
database, about 80% of the time an exception gets thrown after the first
product line data is returned. The message from the exception is
"undefined method `name' for nil:NilClass".
This problem does not happen with MySQL nor Oracle as the database. So,
it appears to be something to do with the database. I am using
activerecord-sqlserver-adapter with a system DSN to connect to the
database. I also had to move from Ruby 1.8.7 back to 1.8.6 to get the
adapter to work at all. I have seen references to using ADO or ODBC
So my questions are:
1. Has anybody else had a similar problem?
2. What database adapter is the proper one to use with SQL Server?
Thanks in advance!