jruby/activerecord-jdbc-adapter — Issue #143: ROW_NUMBER function does not exist in SQL server 2000 legacy database
Author: wtang2006
Created: 2011-12-06 11:21:20+00:00
State: open

I am trying to get a Rails 3 application to work with SQL Server 2000 using activerecord-jdbc-adapter. this is the error:

ActiveRecord::JDBCError: 'ROW_NUMBER' is not a recognized function name.: SELECT t.* FROM (SELECT ROW_NUMBER() OVER(ORDER BY [pencils].id) AS _row_num, [pencils].* FROM [pencils] WHERE [pencils].[id] = 1) AS t WHERE t._row_num BETWEEN 1 AND 1

Apparently this is NOT a simple problem. there are still a lot of SQL server 2000 out there (and I am working with one of them).

Is there any way you can consider supporting this?