Hi, I trieed umpteen times to connect ruby on rails to MSSQL server using the standard procedures and I always get the samw error. As I was previously working with MYSQL I faced no problem .Now at a time critical situation I need a solution for this........... Open OLE error code:800A0E7A in ADODB.Connection Provider cannot be found. It may not be properly installed. HRESULT error code:0x80020009 Exception occurred. RAILS_ROOT: ./script/../config/.. Application Trace <> | Framework Trace <> | Full Trace <> C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:57:in `connect'' C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:424:in `connect'' C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:215:in `connect'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ connection_adapters/sqlserver_adapter.rb:41:in `sqlserver_connection'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ connection_adapters/abstract/connection_specification.rb:251:in `connection_without_query_cache='' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ query_cache.rb:54:in `connection='' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ connection_adapters/abstract/connection_specification.rb:220:in `retrieve_connection'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ connection_adapters/abstract/connection_specification.rb:78:in `connection'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ base.rb:696:in `columns'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ calculations.rb:216:in `column_for'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ calculations.rb:138:in `calculate'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ calculations.rb:66:in `count'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/pagination.rb:172:in `count_collection_for_pagination'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/pagination.rb:196:in `paginator_and_collection_for'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/pagination.rb:129:in `paginate'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/scaffolding.rb:109:in `list'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/scaffolding.rb:97:in `index'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/base.rb:941:in `perform_action_without_filters'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/filters.rb:368:in `perform_action_without_benchmark'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/benchmarking.rb:69:in `perform_action_without_rescue'' C:/Program Files/Ruby/lib/ruby/1.8/benchmark.rb:293:in `measure'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/benchmarking.rb:69:in `perform_action_without_rescue'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/rescue.rb:82:in `perform_action'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/base.rb:408:in `process_without_filters'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/filters.rb:377:in `process_without_session_management_support'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/session_management.rb:117:in `process'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/dispatcher.rb:38:in `dispatch'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick_server.rb:115: in `handle_dispatch'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick_server.rb:81:i n `service'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/server.rb:95:in `start'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/server.rb:92:in `start'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/server.rb:23:in `start'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/server.rb:82:in `start'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick_server.rb:67:i n `dispatch'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/commands/servers/webri ck.rb:59 C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support /dependencies.rb:147:in `require'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/commands/server.rb:30 C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support /dependencies.rb:147:in `require'' script/server:3 C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:57:in `connect'' C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:424:in `connect'' C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:215:in `connect'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ connection_adapters/sqlserver_adapter.rb:41:in `sqlserver_connection'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ connection_adapters/abstract/connection_specification.rb:251:in `connection_without_query_cache='' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ query_cache.rb:54:in `connection='' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ connection_adapters/abstract/connection_specification.rb:220:in `retrieve_connection'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ connection_adapters/abstract/connection_specification.rb:78:in `connection'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ base.rb:696:in `columns'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ calculations.rb:216:in `column_for'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ calculations.rb:138:in `calculate'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/ calculations.rb:66:in `count'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/pagination.rb:172:in `count_collection_for_pagination'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/pagination.rb:196:in `paginator_and_collection_for'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/pagination.rb:129:in `paginate'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/scaffolding.rb:109:in `list'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/scaffolding.rb:97:in `index'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/base.rb:941:in `perform_action_without_filters'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/filters.rb:368:in `perform_action_without_benchmark'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/benchmarking.rb:69:in `perform_action_without_rescue'' C:/Program Files/Ruby/lib/ruby/1.8/benchmark.rb:293:in `measure'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/benchmarking.rb:69:in `perform_action_without_rescue'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/rescue.rb:82:in `perform_action'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/base.rb:408:in `process_without_filters'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/filters.rb:377:in `process_without_session_management_support'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controlle r/session_management.rb:117:in `process'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/dispatcher.rb:38:in `dispatch'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick_server.rb:115: in `handle_dispatch'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick_server.rb:81:i n `service'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/server.rb:95:in `start'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/server.rb:92:in `start'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/server.rb:23:in `start'' C:/Program Files/Ruby/lib/ruby/1.8/webrick/server.rb:82:in `start'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick_server.rb:67:i n `dispatch'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/commands/servers/webri ck.rb:59 C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support /dependencies.rb:147:in `require'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/commands/server.rb:30 C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'' C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support /dependencies.rb:147:in `require'' script/server:3 Request Parameters: None Show session dump <> --- flash: !map:ActionController::Flash::FlashHash {} Response Headers: {"cookie"=>[], "Cache-Control"=>"no-cache"} Thanks.