[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Ruby | Ruby on Rails | database MS SQL Server 2005

Erstwhile Joe

9/26/2007 12:41:00 AM

How can I configure Ruby and Ruby on Rails for use with MS SQL Server
2005?

Environment:
* Ruby 1.8.6-25 (windows)
* Ruby on Rails 1.2.3
* ruby-dbi 0.1.1 (installed with dbi,dbd_ado)
* OS: Windows XP Professional sp4
* Database: MS SQL Server Express 2005 (bonus and on MS SQL Server
2000)

I have attempted to use the following definitions:

development:
adapter: sqlserver
database: event_development
username: sa
password: password
host: DBI:ADO:Provider=SQLNCLI;Data Source=localhost;Initial
Catalog=event_development;User Id=sa;Password=password;

development:
adapter: sqlserver
database: event_development
username: sa
password: password
host: localhost

development:
adapter: sqlserver
database: event_development
username: sa
password: password
host: localhost
mode: DBI:ADO
provider: SQLNCLI

Any help will be appreciated!
--
Posted via http://www.ruby-....
3 Answers

Mark Gallop

9/26/2007 4:57:00 AM

0

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

rubygujarat

9/27/2007 5:25:00 AM

0

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

Damjan Rems

9/27/2007 8:49:00 AM

0

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-....