Using DBI with Mysql problem

< :the previous in number ^ :the list in numerical order > :the next in number P :the previous aricle (the previous thread) N :the next (in thread) |<:the previous thread >|:the next thread ^ :the parent (reply-to) _:the child (an article replying to this) >:the elder article having the same parent <:the youger article having the same parent ---:split window and show thread lists | :split window (vertically) and show thread lists ~ :close the thread frame .:the index ..:the index of indices

Hi,

Win 2000, Ruby Installer 1.66-0.

Trying to get talking to mysql. 

ODBC appears to load (i get a DatabaseError)

E:/Ruby/lib/ruby/site_ruby/1.6/DBD/ODBC/ODBC.rb:71:in `connect': IM002
(0) [Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified(DBI::DatabaseError)
So thats working ok.

But mysql wont load. I get a InterfaceError.

script is simply:

require "dbi"
db = DBI.connect('DBI:Mysql:DTT2', 'root', 'blablabla')
db.disconnect

I get:

E:/Ruby/lib/ruby/site_ruby/1.6/dbi/dbi.rb:426:in `load_driver': Could
not load driver (uninitialized constant Mysql at
DBI::DBD)(DBI::InterfaceError)

Are there some files missing in this distribution or sumting? My disk
looks like:

.... ruby\site_ruby\1.6\ =>

DBD
- Oracle
-- oracle.rb
- ODBC
-- odbc.rb
- Mysql
-- mysql.so
 (Mysql contains mysql.so only. and I had to create mysql folder and
move mysql.so there as it wasn't there origionally - i checked dbd
spec.)
dbi
blablablablabla
blablabla

Any help would be much appreciated.

Thanks
Billy