From: Michael Perle <michael_perle@...>
Date: 2006-08-06T19:35:13+09:00
Subject: DBI/DBD for MySQL

Hi there,

I am a bit confused about the installation for DBI/DBD.

- Is the default build/install of Ruby 1.8.4
   not including the DBI module?
- If no: Is there no Gem available for DBI?
- Is the MySQL DBD not part of the Windows
   binary distribution of Ruby 1.8.2? 1.8.4?
- Is there a way to install the DBD module
   on my laptop where I have no make/gcc/...?

Another question I was asking myself:
When upgrading Ruby, I normally remove and
re-install. Is that the normal way to go?

Thank you for any help
MP

-------------------------------------------------------
Just in case you want to know why I am asking --
but of course you may stop reading and citing here ;-)

Ruby is installed on both
my Linux server (Ruby 1.8.4, build by me) and on
my Windows laptop (Ruby 1.8.2, binary distribution).

On both system Rails is installed, too;
a Rails application using MySQL is working
on the Windows system. On Linux none yet done.

For a Ruby (not Rails) app I need a connection
to MySQL and would like to use DBI.

On Linux (Ruby 1.8.4) the
require 'dbi'
fails already, so it looks like dbi is not installed.

On Windows (Ruby 1.8.2) the require seems ok
but when I try the DBI.connect - is ok on the Win laptop (Ruby 1.8.2)

c:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:499:in `load_driver':
is not a class/module (TypeError)
from c:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:401:
in `_get_full_driver'
from c:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:381:in `connect'
from c:/test/test.rb:5

I would say the DBD for MySQL is not installed.