From: Erstwhile Joe <erstwhileiii@...>
Date: 2007-09-26T09:40:55+09:00
Subject: Ruby | Ruby on Rails | database MS SQL Server 2005

How can I configure Ruby and Ruby on Rails for use with MS SQL Server
2005?

Environment:
* Ruby 1.8.6-25 (windows)
* Ruby on Rails 1.2.3
* ruby-dbi 0.1.1 (installed with dbi,dbd_ado)
* OS: Windows XP Professional sp4
* Database: MS SQL Server Express 2005  (bonus and on MS SQL Server
2000)

I have attempted to use the following definitions:

  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=password;

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

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

Any help will be appreciated!
-- 
Posted via http://www.ruby-forum.com/.