Forum: Ruby on Rails RE: is Sql Server support built in?

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Ross D. (Guest)
on 2006-05-29 10:08
(Received via mailing list)
No but a quick google

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

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
Larry K. (Guest)
on 2006-05-30 09:06
(Received via mailing list)
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
Tom W. (Guest)
on 2006-05-30 14:28
(Received via mailing list)
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=<server>;Database=<schema>;Uid=<user>;Pwd=<password>

Tom
This topic is locked and can not be replied to.