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.