> > Unless people have significant objections, I'll create a ticket and
> > patch to deprecate ADO, and update the wiki instruction pages
> > accordingly.
>
> I don't really know enough about SQLServer to object. I know that I
> had to install the ADO driver to connect to one of my client's
> servers. How would one go about it with ODBC?
Providing you've used the one-click ruby installer for windows, you
shouldn't need to install anything else. Here's an example
database.yml section:
development:
adapter: sqlserver
mode: ODBC
dsn: Driver={SQL Server};Server=(local);Database=rails_development;Uid=sa;Pwd=
As you can see, you can pass a full connection string as the dsn. I'd
like to factor the common parameters out of this string (server, db,
password, user) and use standard yaml
attributes to specify them, but I need to check how this will affect
FreeTDS installations (required to connect from mac, linux) before
doing this.
As an alternative, you can also create a named connection in the Data
Sources control panel, and just pass in the name.
Tom
--
email : tom at popdog.net
_______________________________________________
Rails-core mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails-core
