From: Michael Guterl <mguterl@...>
Date: 2007-01-06T03:13:48+09:00
Subject: Re: ODBC, MS SQL Server

------=_Part_27171_15447663.1168020824627
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 1/5/07, Bolo <malavoi@gmail.com> wrote:
>
> Hello
>
> I try to connect ruby to a MS SQL database . This the error message.
>
> b.michelin@srv-mq-lamp2:~$ irb1.8
> irb(main):001:0> require "dbi"
> => true
> irb(main):002:0> dbh = DBI.connect('dbi:ODBC:DataBase', 'user',
> 'password')
> WARNING: no ODBC driver manager found.
> DBI::DatabaseError: INTERN (0) [RubyODBC]Cannot allocate SQLHENV
>         from /usr/lib/ruby/1.8/DBD/ODBC/ODBC.rb:95:in `connect'
>         from /usr/lib/ruby/1.8/dbi.rb:424:in `connect'
>         from /usr/lib/ruby/1.8/dbi.rb:215:in `connect'
>         from (irb):2
>
> Can You help me


Are you following these instructions?

http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux

If so, did you install Ruby ODBC?  The steps are listed on the page above.

Thanks
>
>
>
HTH,
Michael Guterl

------=_Part_27171_15447663.1168020824627--