> Why not have something like this:
>
> server: &server
>   driver: /opt/local/whatever-driver.so   # or whatever
>   user: my_login
>   password: M$_wh0r3
>   server: 192.168.2.666
>   tds_version: 8.0                                     # if anyone needs this
>
> development:
>   database: rails_development
>   mode: ODBC
>   << *server
>
> special_environment:
>   database: rails_whatever_db
>   mode: ODBC
>   dsn: whatever # overrides any other parameters given
>   << *server

That's pretty much what I have been planning.  There are two issues I
need to watch out for though:

1) The connection string can specify all sorts of extra parameters
(dsns, file dsns, etc), I don't want to remove that for people who
might need it, so the option to specify a 'dsn' must remain (shouldn't
be a problem)

2) FreeTDS may require different connection parameters than ODBC
through windows.  I don't even know if it accepts a full connection
string.  I'd like to be able to specify the following in config.yml,
and connect from windows/mac/linux with minimal extra work:

  development:
    adapter: sqlserver
    database: queen_is_dead
    user: morrissey
    password: shoplifters of the world
    server: smiths1

Tom

P.S

> password: M$_wh0r3

Slash-dot suck-up
_______________________________________________
Rails-core mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails-core

Reply via email to