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.
1f840b624a948a3f39299af25620121b?d=identicon&s=25 Ross Dawson (Guest)
on 2006-05-29 08: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
29b15f133c26b6dac0e4954d61733db9?d=identicon&s=25 Larry Kelly (Guest)
on 2006-05-30 07: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
2f46d76f0e5db4dc318b03be07ebaac4?d=identicon&s=25 Tom Ward (Guest)
on 2006-05-30 12:28
(Received via mailing list)
On 5/29/06, Ross Dawson <Ross_Dawson@aas.kaz.com.au> 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.