This might sound silly, but are you using a Windows-based PC? Judging
by the command line prompt it doesn't appear to be the case. If so then
you should load UNIX ODBC I believe...

Bolo 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
> 
> Thanks