search for: sqlserver_adapter

...sub!'' called for [0, 0, 0, 0, 0, 0, 224, 43]:Array from c:/ruby/lib/ruby/1.8/date/format.rb:253:in ''_parse'' from c:/ruby/lib/ruby/1.8/parsedate.rb:9:in ''parsedate'' from c:/ruby/lib/ruby/1.8/gems/activerecord-1.14.2/lib/active_record_cnnection_adapters/sqlserver_adapter.rb:92:in ''cast_to_time'' from c:/ruby/lib/ruby/1.8/gems/activerecord-1.14.2/lib/active_record_cnnection_adapters/sqlserver_adapter.rb:82:in ''type_cast'' ... I think the problem comes down to sqlserver_adapter.rb, in the type_cast method, asking timestamps to ca...

...------------------------------------------- U activerecord\test\finder_test.rb U activerecord\lib\active_record\base.rb Updated to revision 6912. 1) Error: test_saves_both_date_and_time(DateTimeTest): ArgumentError: argument out of range ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:106:in `mktime'' ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:106:in `cast_to_datetime'' ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:79:in `type_cast'' ./test/../lib/active_record/base.rb:2040:in `read_attribute...

All, Rails 1.1.6. Any AR find() call that generates a SELECT * type query against a table with a DATETIME column in SQL Server whose value occurs before 1970 will fail, because of the coercion of SQL Server datetime types to Time values in Ruby. See sqlserver_adapter.rb line 490 (record[col] = record[col].to_time if record[col].is_a? DBI::Timestamp) If I remove the coercion (just commenting out that line), I can successfully execute these find() calls. I have a couple of questions: 1) Does anyone know of any adverse effects that I will incur by doing this?...

...MyClass.find(:all, :include => :things) I get a weird error: from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract_adapter.rb:120:in `log'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/sqlserver_adapter.rb:485:in `select'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/sqlserver_adapter.rb:233:in `select_all'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/associations.rb:1110:in `select_all_rows'&...

Skipped content of type multipart/alternative-------------- next part -------------- Index: connection_adapters/abstract/connection_specification.rb =================================================================== --- connection_adapters/abstract/connection_specification.rb (revision 4617) +++ connection_adapters/abstract/connection_specification.rb (working copy) @@ -1,10 +1,21 @@ require

hi! after wondering why i can''t find alot of records i eventually found the problem in the sqlserver_adapters implementation of "add_limit_offset!". the problem is when using MSSQL with the sqlserver_adapter paging will only work when at least one column is defined in ":order". for example i was indexing a table with 2912 records, the generated sql for the batches were these: SELECT...

...r using this specification development: adapter: sqlserver database: database_name host: server_name username: user_name password: your_pw_here in database.yml for your SQL Server connection doesn''t work. Some debugging code reveals that only the password comes through into sqlserver_adapter.rb when you use it. I''m not sure why. NOTE - you still have to copy the ADO.rb file per the HOWTO However, this seems to work: development: adapter: sqlserver database: database_name host: DBI:ADO:Provider=SQLOLEDB;Data Source=localhost,1692 username: user_name password: you...

...'' d:/ruby/lib/ruby/gems/1.8/gems/dbi-0.4.1/lib/dbi/handles/driver.rb:33:in `connect'' d:/ruby/lib/ruby/gems/1.8/gems/dbi-0.4.1/lib/dbi.rb:142:in `connect'' d:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-2.2.18/lib/active_record/connection_adapters/sqlserver_adapter.rb:775:in `connect'' d:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-2.2.18/lib/active_record/connection_adapters/sqlserver_adapter.rb:211:in `initialize'' d:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-2.2.18/lib/active_record/connection_adapter...

...ws_per_page, :group => ''members.id, members.last_name, members.first_name, members.phone, members.company_id, companies.name'', :offset => @page * Integer(@user.rows_per_page) ) </pre> While this perfectly ok with MySQL, MS SQL choked on this. And the sqlserver_adapter seems to generic a rather strange looking query which causes the error as the following:- <pre>Exception occurred.: SELECT * FROM (SELECT TOP 7 * FROM (SELECT TOP 7 members.id, members.last_name, members.first_name, members.phone, members.company_id, companies.name FROM members , compan...

...er'' from /usr/lib/ruby/gems/1.8/gems/dbi-0.4.0/lib/dbi.rb:154:in `_get_full_driver'' from /usr/lib/ruby/gems/1.8/gems/dbi-0.4.0/lib/dbi.rb:139:in `connect'' from /usr/lib/ruby/gems/1.8/gems/activerecord-sqlserver- adapter-1.0.0.9250/lib/active_record/connection_adapters/ sqlserver_adapter.rb:47:in `sqlserver_connection'' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/ connection_adapters/abstract/connection_pool.rb:223:in `send'' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/ connection_adapters/abstract/connection_poo...

I just checked out the latest sqlserver_adapter.rb from the SVN repository, and it seems to work fine. -----Original Message----- From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Neville Burnell Sent: Thursday, 24 March 2005 2:25 PM To: r...

/usr/local/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb" -- Posted via http://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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@pu...

...'tally''.): /usr/lib/site_ruby/1.8/DBD/ODBC/ODBC.rb:168:in `execute'' /usr/lib/site_ruby/1.8/dbi/dbi.rb:640:in `execute'' /usr/lib/site_ruby/1.8/dbi/dbi.rb:671:in `select_all'' /vendor/rails/activerecord/lib/active_record/connection_adapters/ sqlserver_adapter.rb:354:in `add_limit_offset!'' /vendor/rails/activerecord/lib/active_record/base.rb:931:in `add_limit!'' /vendor/rails/activerecord/lib/active_record/base.rb:924:in `construct_finder_sql'' Any help appreciated! Jamie ------ class ActionController::Base...

New to rails. Installed rails on my XP desktop, and setup my first app that will use an existing SQLServer database. I am able to connect to SQLServer using odbc with following code. require ''rubygems'' require ''ActiveRecord'' ActiveRecord::Base.establish_connection( :adapter => ''sqlserver'', :mode => ''odbc'', :dsn

...in `load_driver'' c:/program files/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:401:in `_get_full_driver'' c:/program files/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:381:in `connect'' E:/OpenSource/Ruby/rails/trunk/activerecord/test/../lib/active_record/connec tion_adapters/sqlserver_adapter.rb:46:in `sqlserver_connection'' E:/OpenSource/Ruby/rails/trunk/activerecord/test/../lib/active_record/connec tion_adapters/abstract_adapter.rb:148:in `send'' E:/OpenSource/Ruby/rails/trunk/activerecord/test/../lib/active_record/connec tion_adapters/abstract_adapter.rb:148:in `c...

...'tally''.): /usr/lib/site_ruby/1.8/DBD/ODBC/ODBC.rb:168:in `execute'' /usr/lib/site_ruby/1.8/dbi/dbi.rb:640:in `execute'' /usr/lib/site_ruby/1.8/dbi/dbi.rb:671:in `select_all'' /vendor/rails/activerecord/lib/active_record/connection_adapters/ sqlserver_adapter.rb:354:in `add_limit_offset!'' /vendor/rails/activerecord/lib/active_record/base.rb:931:in `add_limit!'' /vendor/rails/activerecord/lib/active_record/base.rb:924:in `construct_finder_sql'' /vendor/rails/activerecord/lib/active_record/base.rb:395:in `find...

Hello all, I''ve spent a while looking for a sniff of this on the wiki or google at large.. Does migrations work for SQL Server on 1.0 ? -- ------------------------------ Joyeux Noël ------------------------------ Peter Fitzgibbons _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org

Hello Everyone, I have been reading this mailing list for a while and am impressed with the generous help that many here are eager to provide. Perhaps someone will be able to shed some light on a configuration issue I am having. Thank you in advance for any assistance. First, system setup details: #System Setup# * OS: Fedora Core 4 running in a VMWare box on Windows XP * Database: MS SQL

...9;'2006-07-14 11:07:15'', ''21002128420200179838'', '''', '' aCaixa'', 4110278, ''N'') (ActiveRecord::StatementInvalid) from ./script/../config/../vendor/rails/activerecord/lib/ active_record/ onnection_adapters/sqlserver_adapter.rb:279:in `insert'' from ./script/../config/../vendor/rails/activerecord/lib/ active_record/ ase.rb:1739:in `create_without_callbacks'' from ./script/../config/../vendor/rails/activerecord/lib/ active_record/ allbacks.rb:261:in `create_without_timestamps''...

...ive_support/core_ext/kernel/reporting.rb:11:in `silence_warnings'' D:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/core_ext/kernel/requires.rb:5:in `require_library_or_gem'' D:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/sqlserver_adapter.rb:28:in `sqlserver_connection'' D:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:292:in `send'' D:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract/connection_sp...