From: Damjan Rems <d_rems@...>
Date: 2007-09-27T17:48:51+09:00
Subject: Re: Ruby | Ruby on Rails | database MS SQL Server 2005

unknown wrote:
> On Sep 26, 9:57 am, Mark Gallop <mark.gal...@gmail.com> wrote:
>>     :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

development:
#  adapter: mssqlclient
  adapter: sqlserver
  database: mydb
  host: localhost  # or myhost.at.com
  username: myName
  password: myPwd
  charset: unicode

This was my configuration back when I was testing some stuff. My problem 
was that all number type fields (real, double, fix...) were returned as 
null and it was useless for me.

You can also try mssqlclient.


by
TheR
-- 
Posted via http://www.ruby-forum.com/.