RE: is Sql Server support built in?


#1

No but a quick google

http://www.google.com.au/search?q=ruby+rails+MS+sql+server+adapter

produces this

http://justinram.wordpress.com/tag/ruby/ruby-on-rails/

Without looking I’m guessing it uses COM to talk to ADO which I suspect
would add some overhead.

This http://www.loudthinking.com/arc/000534.html being the first article
at the top of the search is interesting too.

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.

HTH

Ross


#2

Thanks, Ross.

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.

-Larry


#3

On 5/29/06, Ross D. removed_email_address@domain.invalid wrote:

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:

production:
adapter: sqlserver
mode: ODBC
dsn: Driver={SQL
Server};Server=;Database=;Uid=;Pwd=

Tom