Problem with Ruby ODBC in Linux

Ruby
1

Hi,

I am trying to connect to a SQL Server 7.0 DB from a Linux box using
Ruby DBI & ODBC.

  1. ruby -v
    ruby 1.8.6 (2007-03-13 patchlevel 0) [i686-linux]

  2. ruby-odbc installed ok.
    ruby-odbc-0.9995> ruby test.rb dsn_name username password
    all tests ok!

  3. DBI is properly installed.
    irb> require ‘dbi’
    => true

BUT, the following fails in the same irb session.

irb> DBI.connect(‘dbi:ODBC:dsn_name’, ‘username’, password’)
DBI::InterfaceError: Unable to load driver ‘ODBC’
…

What is missing?
Or how can I track it down?

Mysql works fine.
I believe I set up the ODBC configuration correctly.
I can access the SQL Server via isql command.

Thanks.

Sam

2

I fixed the problem.

I reinstalled Ruby DBI.

ruby setup.rb config --with=dbi,dbd_odbc
ruby setup.rb setup
ruby setup.rb install

I think the --with=dbi,dbd_odbc made the difference.

Sam