From: Paul DuBois <paul@...>
Date: 2003-03-13T12:22:14+09:00
Subject: Re: Problem with Mysql in win ruby 1.6.8

At 10:12 +0900 3/13/03, Sergei Dolmatov wrote:
>� ���, 13.03.2003, � 08:56, Greg Brondo �������:
>>  J.Hawkesworth wrote:
>>  > Greg,
>>  > Show us your code - given that it is failing on line 5 hopefully it is
>>  > something simple.
>>  > All the best,
>>  > Jon
>>  >
>>  > -----Original Message-----
>>  > From: Greg Brondo [mailto:greg@brondo.com]
>>  > Sent: 12 March 2003 17:55
>>  > To: ruby-talk ML
>>  > Subject: Problem with Mysql in win ruby 1.6.8
>>  >
>>  >
>>  > I've installed the PP 1.6.8 version of Ruby for windows.  It comes with
>>  > DBI and Mysql support.  However, when I run a test.rb script I wrote
>>  > (basically the stuff from the Mysql-DBI homepage).  I get this error:
>>  >
>>  > c:/ruby/lib/ruby/site_ruby/1.6/dbi/dbi.rb:424:in `load_driver': Could
>>  > not load driver (uninitialized constant Mysql at DBI::DBD)
>>  > (DBI::InterfaceError)
>>  >          from c:/ruby/lib/ruby/site_ruby/1.6/dbi/dbi.rb:339:in
>>  > '_get_full_driver'
>>  >          from c:/ruby/lib/ruby/site_ruby/1.6/dbi/dbi.rb:319:in `connect'
>>  >          from C:\webdev\LLI-FRN\test.rb:5
>
>Looks like you didn't install mysql-ruby. It's ruby interface for MySQL
>API.

I don't think this is it.  It's failing even to find the DBI MySQL driver,
before that driver attempts to use mysql-ruby.

If you look in c:\ruby\lib\ruby\site_ruby\1.6\dbi, is there a directory
named DBD and does that directory have a subdirectory named Mysql?
And do those directories have exactly that capitalization? ("DBD" and "Mysql")?

>  > require 'dbi'
>>
>>  begin
>>       # connect to the MySQL server
>>       dbh = DBI.connect("DBI:Mysql:test", "root", "")
>>       # get server version string and display it
>>       row = dbh.select_one("SELECT VERSION()")
>>       puts "Server version: " + row[0]
>>       dbh.select_all("select * from types") do |row|
>>         puts row[0].to_s + "  " + row[1]
>>       end
>>  rescue DBI::DatabaseError => e
>>       puts "An error occurred"
>>       print "Error code: ", e.err, "\n"
>>       print "Error message: ", e.errstr, "\n"
>>  ensure
>>       # disconnect from server
>>       dbh.disconnect if dbh
>>  end
>>
>>
>>  'Child' suggested that maybe I do not have the Mysql DBI stuff
>>  installed.  I downloaded the mysql-win package and ran install.rb.  It
>>  said everything installed fine but I still receive the error.  I can
>>  access the DB through DBI:ODBC but I prefer a more native approach.
>>  I'm using Ruby installer 1.6.8 which according to the docs includes
>>  everything I need (at least I think -- I'm coming from Python so some of
>>  this is a bit trickier to get working on Windows).
>>
>>  Thanks!
>>  Greg Brondo
>>
>>