« Moving on...up? | Main | Allowing Apache and IIS to use the same port on a windows machine »
April 25, 2005
Ruby on Rails using SQL Server
If you are attempting to use MSSQL (that is Microsoft sql server) instead of MySQL there are two things you need to do.
First get the up to date ruby-dbi-all-x.x.xx.tar.gz (version 0.0.23 at time of writing..) from the Rubyforge page Ruby Forge DBI page. The instructions to install the ADO driver can be found on the Ruby on Rails community pages.
and second, and most important, get the patch for the add_limit_with_offset method/function (still not sure of the nomenclature for these things..) and cut and paste it into the sqlserver_adapter.rb file in x:\dev\Ruby\lib\ruby\gems\1.8\gems\activerecord-1.10.1\lib\active_record\connection_adapters\ directory.
Otherwise you will never get past the NoMethodError screen.
Posted by dottie at April 25, 2005 12:02 AM