Paul DuBois wrote:
> 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
>>>
>>>
> 
> 
Ok.  I looked in the directory structure.  Under 1.6 there is a DBD and 
dbi.  There Is NOT a Mysql under dbi.  Under 'i586-mswin32' there is a 
mysql.so but that is all.

Thanks!
Greg B.