Ruby on Rails | MS SQL Server 2005 | Configuration

Rails
1

Request: Full description of mechanims required to intergrate current
Ruby / Ruby on Rails with MS SQL Server 2005

Environment:

  • Ruby 1.8.6-25
    (ruby 1.8.6 (2007-03-13 patchlevel 0) [i386-mswin32])
  • Rails 1.2.3
  • ruby-dbi 0.1.1 (installed dbi,dbd_ADO)
  • OS: Windows XP Professional sp4
  • MS SQL Server Express 2005 installed on local machine

Background:
I have used various settings for the config.db to no avail. These have
included (where sa / password ARE the credentials for the database
referenced):

development:
adapter: sqlserver
database: event_development
username: sa
password: password
host: localhost
mode: DBI:ADO
provider: SQLNCLI

development:
adapter: sqlserver
database: event_development
username: sa
password: password
host: DBI:ADO:Provider=SQLNCLI;Data Source=localhost;Initial
Catalog=event_development;User Id=sa;Password=Marimba;

development:
adapter: sqlserver
database: event_development
username: sa
password: password
host: localhost

Any help will be appreciated.

Regards

2

If you have installed the DBI ado.rb file in the /ADO folder… then
this is
what you need.

development:
adapter: sqlserver
database: event_development
username: sa
password: password
host: localhost

What’s the specific error message you get?

3

Since I no longer use Windows for my day job, I’m not sure if I have a
good
database.yml for SQL Server 2005 documented anywhere. However, I’ll have
a
look and get back to you.

Craig