Ok I followed the steps for setting up ruby and rails on my Vista machine and I am having a problem connecting to the database.

Contents of database.yml

development:
  adapter: sqlserver
  database: APPS_SETUP
  Host: WindowsVT06\SQLEXPRESS
  Username: se
  Password: paswd

Run rake db:migrate from myapp directory

----------
rake aborted!
no such file to load -- deprecated

ADO

I have dbi 0.4.0 installed and have created the ADO folder in

C:\Ruby\lib\ruby\site_ruby\1.8\DBD\ADO

I got the ado.rb from the dbi 0.2.2

What else should I be looking at to fix the issue connecting to the database? Please don't tell me to use MySql or Sqlite or Postgres.

****UPDATE****

I have installed the activerecord-sqlserver-adapter gem from --source=http://gems.rubyonrails.org

Still not working.

I have verified that I can connect to the database by logging into SQL Management Studio with the credentials.

rake db:migrate --trace

PS C:\Inetpub\wwwroot\myapp> rake db:migrate --trace
(in C:/Inetpub/wwwroot/myapp)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
no such file to load -- deprecated
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.1/lib/active_support/dependencies.rb:510:in `require'
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/dependencies.rb:355:in `new_constants_in'
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/dependencies.rb:510:in `require'
C:/Ruby/lib/ruby/site_ruby/1.8
sql-server ruby-on-rails windows ruby
Edit
Report