From: rubygujarat@...
Date: 2007-09-27T14:25:13+09:00
Subject: Re: Ruby | Ruby on Rails | database MS SQL Server 2005

On Sep 26, 9:57 am, Mark Gallop <mark.gal...@gmail.com> wrote:
> Hi Joe,
>
> Erstwhile Joe wrote:
> > How can I configure Ruby and Ruby on Rails for use with MS SQL Server
> > 2005?
>
> I haven't used ADO but have been successfully using ODBC to connect to a
> mssql server. This is how I created the connection:
>
>   ActiveRecord::Base.establish_connection( :adapter => 'sqlserver',
>     :mode => 'odbc',
>     :dsn => 'MyDSName',
>     :username => 'bob',
>     :password => 'bob')
>
> I added bob as a local user (maybe domain users also work) and created
> the ODBC connection called MyDSName.
>
> Cheers,
> Mark

hi
Can you kindly helpo me more on this.

I am using sql2005 express on my machine.

My server name is : RubyGujarat
username:- sa
password:- mytest

can you help me , how should i mention this in the code given by you
above.

Thanks

IronRuby