Rails - May 2006 - is Sql Server support built in?

Have installed ruby-one-click installer 1.8.4-16 and rails.  Am unable to
get an app to talk to by SS2000 database using adapter:  sqlserver.  Is Sql
Server support built-in, or do I need to install something else?

-- 
Best Regards,
-Larry
"Work, work, work...there is no satisfactory alternative."
            --- E.Taft Benson
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060529/bbf1aa03/attachment.html

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
-----Original Message-----
From: rails-bounces@lists.rubyonrails.org
[mailto:rails-bounces@lists.rubyonrails.org]On Behalf Of Larry Kelly
Sent: Monday, 29 May 2006 3:40 PM
To: Rails@lists.rubyonrails.org
Subject: [Rails] is Sql Server support built in?


Have installed ruby-one-click installer 1.8.4-16 and rails.  Am unable to get an
app to talk to by SS2000 database using adapter:  sqlserver.  Is Sql Server
support built-in, or do I need to install something else?

-- 
Best Regards,
-Larry
"Work, work, work...there is no satisfactory alternative."
            --- E.Taft Benson

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

On 5/28/06, Ross Dawson <Ross_Dawson@aas.kaz.com.au>
wrote:
>
> 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
> -----Original Message-----
> From: rails-bounces@lists.rubyonrails.org [mailto:
> rails-bounces@lists.rubyonrails.org]On Behalf Of Larry Kelly
> Sent: Monday, 29 May 2006 3:40 PM
> To: Rails@lists.rubyonrails.org
> Subject: [Rails] is Sql Server support built in?
>
>
> Have installed ruby-one-click installer 1.8.4-16 and rails.  Am unable to
> get an app to talk to by SS2000 database using adapter:  sqlserver.  Is Sql
> Server support built-in, or do I need to install something else?
>
> --
> Best Regards,
> -Larry
> "Work, work, work...there is no satisfactory alternative."
>             --- E.Taft Benson
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>


-- 
Best Regards,
-Larry
"Work, work, work...there is no satisfactory alternative."
            --- E.Taft Benson
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060530/e8ce9842/attachment.html

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