Unless you have a specific need for MS SQL Server (Legacy DB etc.) then
consider one of the open source alternatives (MySQL, Postgres etc.) and
make your Rails app cross platform, opening up greater
hosting/deployment options.
Yes, this is partly a Legacy DB issue. Also, I haven’t found an
equivalent
for SS2000’s graphical relationship viewer, which helps me deal with
schemas
with large numbers of tables.
Without looking I’m guessing it uses COM to talk to ADO which I suspect would add some overhead.
The SQL Server adapter can connect in two ways; ADO (which as you
guessed uses win32ole, only works on windows and requires the ADO dbi
adapter to be installed), and ODBC (which works out of the box on
windows but requires freetds on Linux/OS X)
To connect with ODBC (from windows) you need a database.yml entry like
this: