# ADO error

**URL:** <https://www.ruby-forum.com/t/ado-error/142678>\
**Category:** Rails\
**Created:** [July 10, 2008, 10:31am UTC](https://www.ruby-forum.com/t/ado-error/142678 "2008-07-10T10:31:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sumantacaptain](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/8491ac/32.png) [@sumantacaptain](https://www.ruby-forum.com/u/sumantacaptain)\
**Post date:** [July 10, 2008, 10:31am UTC](https://www.ruby-forum.com/t/ado-error/142678/1 "2008-07-10T10:31:33Z")

</div>

hi,  
i want to accept a sql server 2005 db, have configured .yml file and  
loaded sql adapter yet am getting the following error  
DBI::InterfaceError in Rails/infoController#properties  
Could not load driver (no such file to load – c:/ruby/lib/ruby/  
site\_ruby/1.8/dbd/ADO)RAILS\_ROOT: C:/test

Application Trace | Framework Trace | Full Trace  
c:/ruby/lib/ruby/site\_ruby/1.8/dbi.rb:368:in `load_driver' c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:233:in`\_get\_full\_driver’  
c:/ruby/lib/ruby/site\_ruby/1.8/dbi.rb:219:in `connect' c:/ruby/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’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/  
connection\_adapters/abstract/connection\_specification.rb:292:in `send' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/connection_specification.rb:292:in`connection=’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/  
connection\_adapters/abstract/connection\_specification.rb:260:in  
`retrieve_connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/connection_specification.rb:78:in`connection’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/  
query\_cache.rb:8:in `cache' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ caching/sql_cache.rb:12:in`perform\_action’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action\_controller/  
base.rb:529:in `send' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ base.rb:529:in`process\_without\_filters’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action\_controller/  
filters.rb:569:in `process_without_session_management_support' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ session_management.rb:130:in`process’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action\_controller/  
base.rb:389:in `process' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:149:in`handle\_request’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action\_controller/  
dispatcher.rb:107:in `dispatch' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:104:in`synchronize’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action\_controller/  
dispatcher.rb:104:in `dispatch' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:120:in`dispatch\_cgi’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action\_controller/  
dispatcher.rb:35:in `dispatch' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb: 112:in`handle\_dispatch’  
c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick\_server.rb:78:in  
`service' c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in`service’  
c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' c:/ruby/lib/ruby/1.8/webrick/server.rb:173:in`start\_thread’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:162:in`start\_thread’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:95:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:92:in`each’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:92:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:23:in`start’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:82:in `start' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb:62:in`dispatch’  
c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/commands/servers/  
webrick.rb:66  
c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`gem_original_require' c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in`require’  
c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active\_support/  
dependencies.rb:509:in `require' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ dependencies.rb:354:in`new\_constants\_in’  
c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active\_support/  
dependencies.rb:509:in `require' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/commands/server.rb:39 c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in`gem\_original\_require’  
c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`require' script/server:3c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:368:in`load\_driver’  
c:/ruby/lib/ruby/site\_ruby/1.8/dbi.rb:233:in `_get_full_driver' c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:219:in`connect’  
c:/ruby/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' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/connection_specification.rb:292:in`send’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/  
connection\_adapters/abstract/connection\_specification.rb:292:in  
`connection=' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/connection_specification.rb:260:in`retrieve\_connection’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/  
connection\_adapters/abstract/connection\_specification.rb:78:in  
`connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ query_cache.rb:8:in`cache’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action\_controller/  
caching/sql\_cache.rb:12:in `perform_action' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ base.rb:529:in`send’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action\_controller/  
base.rb:529:in `process_without_filters' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ filters.rb:569:in`process\_without\_session\_management\_support’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action\_controller/  
session\_management.rb:130:in `process' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ base.rb:389:in`process’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action\_controller/  
dispatcher.rb:149:in `handle_request' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:107:in`dispatch’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action\_controller/  
dispatcher.rb:104:in `synchronize' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:104:in`dispatch’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action\_controller/  
dispatcher.rb:120:in `dispatch_cgi' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:35:in`dispatch’  
c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick\_server.rb:  
112:in `handle_dispatch' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb:78:in`service’  
c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in`run’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' c:/ruby/lib/ruby/1.8/webrick/server.rb:162:in`start’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' c:/ruby/lib/ruby/1.8/webrick/server.rb:95:in`start’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:92:in `each' c:/ruby/lib/ruby/1.8/webrick/server.rb:92:in`start’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:23:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:82:in`start’  
c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick\_server.rb:62:in  
`dispatch' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/commands/servers/ webrick.rb:66 c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in`gem\_original\_require’  
c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`require' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ dependencies.rb:509:in`require’  
c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active\_support/  
dependencies.rb:354:in `new_constants_in' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ dependencies.rb:509:in`require’  
c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/commands/server.rb:39  
c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`gem_original_require' c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in`require’  
script/server:3Request  
Parameters:

None  
Show session dump

* * *

flash: !map:ActionController::Flash::FlashHash {}

Response  
Headers:

{“cookie”=\>[],  
“Cache-Control”=\>“no-cache”}

plz help

thnx in advance

---

<div class="post-metadata">

**Author:** ![sumantacaptain](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/8491ac/32.png) [@sumantacaptain](https://www.ruby-forum.com/u/sumantacaptain)\
**Post date:** [July 10, 2008, 1:24pm UTC](https://www.ruby-forum.com/t/ado-error/142678/2 "2008-07-10T13:24:12Z")

</div>

You need the ADO DBD. See:  
[http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer](http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer)  
.

Regards,  
Craig