From: beripome@... (Billy)
Date: 2002-02-24T10:01:50+09:00
Subject: Re: Using DBI with Mysql problem

Hi,

I thought so (duh). Installed and works great now. Thanks for the link
Michael. I just thought that these packages were included in the
1.66-0 installer.
Release notes say:

                          Ruby                1.6.6
                          FXRuby w/OpenGL     0.99.189
                          TclTk               8.3
                          TestUnit            2/9/2002
                          RDoc                alpha-a
                          Rexml               1.2.5
                          win32ole            0.3.3
                          XMLParser           0.6.1
                          Ruby/DBI            0.0.12
                          DBD/ODBC            0.94
                          DBD/Postgres        0.6.5
                          DBD/MySql           2.4.2
                          DBD/oracle          0.2.11
                          ProgrammingRuby     3a

Its most likely my fault for not installing properly or something but
has someone made a boobie and not actually included all needed files?

Cheers,
Billy

520079130762-0001@t-online.de (Michael Neumann) wrote in message news:<20020223141959.GA9083@michael.neumann.all>...
> Billy wrote:
> > 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.)
> 
> The Mysql.rb file (MySQL DBD) is missing!
> 
> You can get it manually from http://ruby-dbi.sf.net.
> 
> Regards,
> 
>   Michael