Aside from the migrations and database.yml, have you changed any other code in the app?
On Apr 28, 7:10 am, Norman Smith <[email protected]> wrote: > 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 > instead. > > 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! > Norm > -- > Posted viahttp://www.ruby-forum.com/. > > -- > 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group > athttp://groups.google.com/group/rubyonrails-talk?hl=en. -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
