Ruby on Rails

I am using authlogic for authentication in rails 3.0.3 with ruby 1.9.2
Using activerecord-sqlserver-adapter (3.0.5)
windows with sqlserver database

when i create user details in rails console, i am getting below error,
>User.create(:login=>'test',:password=>'test123',:password_confirmation=>'test123')
ActiveRecord::StatementInvalid: ODBC::Error: 37000 (102)
[Microsoft][ODBC SQL Se
rver Driver][SQL Server]Incorrect syntax near 'LIMIT'.: SELECT
[users].[id] FROM
[users] WHERE (LOWER([users].[login]) = LOWER(N'test')) LIMIT 1
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/connection_adapters/abstract_adapter.rb:202:in `rescue in log'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/connection_adapters/abstract_adapter.rb:194:in `log'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-sqlserver-adapter-3.0
.5/lib/active_record/connection_adapters/sqlserver/database_statements.rb:249:in
`raw_select'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-sqlserver-adapter-3.0
.5/lib/active_record/connection_adapters/sqlserver/database_statements.rb:193:in
`select'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/connection_adapters/abstract/database_statements.rb:7:in `select_all'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/connection_adapters/abstract/query_cache.rb:56:in `select_all'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/base.rb:467:in `find_by_sql'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/relation.rb:64:in `to_a'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/relation/finder_methods.rb:333:in `find_first'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/relation/finder_methods.rb:122:in `first'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/relation/finder_methods.rb:180:in `exists?'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/validations/uniqueness.rb:39:in `validate_each'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activemodel-3.0.3/lib/active_model
/validator.rb:154:in `block in validate'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activemodel-3.0.3/lib/active_model
/validator.rb:151:in `each'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activemodel-3.0.3/lib/active_model
/validator.rb:151:in `validate'
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_sup
port/callbacks.rb:314:in `_callback_before_85'

--
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@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.