I have tried all those sites this week myself, the best solution was
found at the following link:
http://installingcats.com/2007/12/13/mysql-ruby-gem-install-problem-on-mac-os-x-leopard/
once this was finished, I was able to go into IRB and type
require"MySql" and all worked fine.

On Jul 22, 1:36 pm, TomRossi7 <t...-5bxIUPmzHicFraO2wh7vUA@public.gmane.org> wrote:
> This has been a long painful day and I am hoping someone can help.  I
> am trying to get my Rails application running on Mac/Leopard to
> connect to a Microsoft SQL server.  I have followed the instructions

> athttp://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLSer....

>
> Everything appears to work until I get to IRB.  In other words, I can
> use iodbc and tsql with no problem.  But when I go into IRB and run
> require 'dbi', I get the following error:
>
> LoadError: no such file to load -- dbi
>         from /Library/Ruby/Site/1.8/rubygems/custom_require.rb:27:in
> `gem_original_require'
>         from /Library/Ruby/Site/1.8/rubygems/custom_require.rb:27:in
> `require'
>         from (irb):1
>         from :0
>
> According to MacPorts, I have installed
> rb-dbi <at> 0.1.1_1+dbd_odbc (active)
> rb-odbc <at> 0.9995_0 (active)
>
> What am I missing?
>
> Thanks!
> Tom