# Problem in connecting Rails to MS SQL Server 2000

**URL:** <https://www.ruby-forum.com/t/problem-in-connecting-rails-to-ms-sql-server-2000/105269>\
**Category:** Rails\
**Created:** [May 28, 2007, 10:10am UTC](https://www.ruby-forum.com/t/problem-in-connecting-rails-to-ms-sql-server-2000/105269 "2007-05-28T10:10:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![paragados](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/f0a364/32.png) [@paragados](https://www.ruby-forum.com/u/paragados)\
**Post date:** [May 28, 2007, 10:10am UTC](https://www.ruby-forum.com/t/problem-in-connecting-rails-to-ms-sql-server-2000/105269/1 "2007-05-28T10:10:04Z")

</div>

Hello,  
Im’ new to Ruby and Rails. I had trouble in connecting to database. I  
used MS SQL Server 2000. I had follow the instructions in conncecting in  
some site tutorial however when I run my web application I get these  
errors.

E:/INSTAN~1/ruby/lib/ruby/site\_ruby/1.8/dbi/dbi.rb:499:in `load_driver’ E:/INSTAN~1/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:401:in `\_get\_full\_driver’  
E:/INSTAN~1/ruby/lib/ruby/site\_ruby/1.8/dbi/dbi.rb:381:in `connect’ E:/INSTAN~1/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/sqlserver_adapter.rb:46:in `sqlserver\_connection’  
E:/INSTAN~1/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:262:in  
`send’ E:/INSTAN~1/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in `connection\_without\_query\_cache=’  
E:/INSTAN~1/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/query\_cache.rb:54:in  
`connection=’ E:/INSTAN~1/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:230:in `retrieve\_connection’  
E:/INSTAN~1/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:78:in  
`connection’ E:/INSTAN~1/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:763:in `columns’  
E:/INSTAN~1/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/calculations.rb:257:in  
`column_for’ E:/INSTAN~1/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/calculations.rb:116:in `calculate’  
E:/INSTAN~1/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/calculations.rb:45:in  
`count’ E:/INSTAN~1/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/pagination.rb:173:in `count\_collection\_for\_pagination’  
E:/INSTAN~1/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_controller/pagination.rb:197:in  
`paginator_and_collection_for’ E:/INSTAN~1/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/pagination.rb:130:in `paginate’  
#{RAILS\_ROOT}/app/controllers/journals\_controller.rb:12:in `list’ #{RAILS_ROOT}/app/controllers/journals_controller.rb:3:in `index’

Please give me insights on what I should I do with this errors. or which  
file I had made a mistake. i’m having a hard time understanding these  
errors but unfortunately I failed to solved.

This is my database.yml  
development:  
adapter: sqlserver  
database: Journal  
username: sa  
password: root  
host: [sqlserver.APO.com](http://sqlserver.APO.com)

test:  
adapter: sqlserver  
database: Journal  
username: sa  
password: root  
host: [sqlserver.APO.com](http://sqlserver.APO.com)

production:  
adapter: sqlserver  
database: Journal  
username: sa  
password: root  
host: [sqlserver.APO.com](http://sqlserver.APO.com)

Any help is highly appreciated. I really need this for my web  
application.  
Thanks in advance.  
Or you can email the reply to my email address  
removed\_email\_address@domain.invalid