tag:blogger.com,1999:blog-8594555787119913827.post7015438258573128750..comments2023-03-03T00:29:29.460-08:00Comments on Random Thoughts: Rails 3 with SQLServer 2000Unknownnoreply@blogger.comBlogger6125tag:blogger.com,1999:blog-8594555787119913827.post-43812808189878817072014-06-03T08:58:05.402-07:002014-06-03T08:58:05.402-07:00Hi Thomas. We are using Rails 4.0.4. We spend many...Hi Thomas. We are using Rails 4.0.4. We spend many time trying using sqlserver 2000. We try with ODBC, with Freetds without success. I tried to use your gem but we have problems.<br /><br />First one is:<br />ArgumentError: wrong number of arguments (2 for 1)<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/bundler/gems/activerecord-sqlserver-adapter-340f3d696bdc/lib/arel/visitors/sqlserver.rb:93:in `visit_Arel_Nodes_SelectStatement'<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/gems/arel-4.0.2/lib/arel/visitors/visitor.rb:22:in `visit'<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/gems/arel-4.0.2/lib/arel/visitors/visitor.rb:5:in `accept'<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in `to_sql'<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:32:in `select_all'<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all'<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/gems/activerecord-4.0.4/lib/active_record/querying.rb:36:in `find_by_sql'<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/gems/activerecord-4.0.4/lib/active_record/relation.rb:585:in `exec_queries'<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/gems/activerecord-4.0.4/lib/active_record/relation.rb:471:in `load'<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/gems/activerecord-4.0.4/lib/active_record/relation.rb:220:in `to_a'<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/gems/activerecord-4.0.4/lib/active_record/relation.rb:573:in `inspect'<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/gems/railties-4.0.4/lib/rails/commands/console.rb:90:in `start'<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/gems/railties-4.0.4/lib/rails/commands/console.rb:9:in `start'<br /> from /home/fi4/rails/bolero31srv/shared/bundle/ruby/2.1.0/gems/railties-4.0.4/lib/rails/commands.rb:62:in `'<br /> from script/rails:6:in `require'<br /> from script/rails:6:in `'<br /><br />It seem that this release is not compatible with Rails 4.0.4. Have you any version Rails 4.x that run with sqlserver 2000?<br /><br /><br />Thanks for your help.<br /><br />expect {your_answer}.to succesfull_answer<br /><br />Thanks.<br />Rafa.<br /> Rafahttps://www.blogger.com/profile/18097925217261898725noreply@blogger.comtag:blogger.com,1999:blog-8594555787119913827.post-41951355509897279802012-07-24T09:45:39.061-07:002012-07-24T09:45:39.061-07:00Again! You keep saving me!Again! You keep saving me!spinks.ahttps://www.blogger.com/profile/07763903917576932119noreply@blogger.comtag:blogger.com,1999:blog-8594555787119913827.post-26281812581369225592012-06-21T08:09:03.125-07:002012-06-21T08:09:03.125-07:00I have a cloned Activerecord-sqlserver-adapter rep...I have a cloned Activerecord-sqlserver-adapter repository at github/twshelton that gets pretty close to solving the problem. The one thing we ran into was the date conversion the new adapter uses and you may need to modify ruby-odbc code to get it to work correctly.Thomas W. Sheltonhttps://www.blogger.com/profile/05745630160956594711noreply@blogger.comtag:blogger.com,1999:blog-8594555787119913827.post-70381896932466339222012-06-06T12:53:49.532-07:002012-06-06T12:53:49.532-07:00Thanks for your post. We're still running a R...Thanks for your post. We're still running a Rails 2 app because of the SQL Server 2000 limitation. I'd be very interested to see what else you've done if you have time to share.Philhttps://www.blogger.com/profile/04826617147889927585noreply@blogger.comtag:blogger.com,1999:blog-8594555787119913827.post-66201762130864162232012-04-26T12:42:08.738-07:002012-04-26T12:42:08.738-07:00I've done a little more work on it over the la...I've done a little more work on it over the last year and have Rails 3.2 connecting to SQLServer 2000 if anyone is interested.Thomas W. Sheltonhttps://www.blogger.com/profile/05745630160956594711noreply@blogger.comtag:blogger.com,1999:blog-8594555787119913827.post-60116425025723914192011-04-06T13:36:00.640-07:002011-04-06T13:36:00.640-07:00thanks for the post!thanks for the post!spinks.ahttps://www.blogger.com/profile/07763903917576932119noreply@blogger.com