From: Justin To <tekmc@...>
Date: 2008-07-02T02:17:42+09:00
Subject: Re: How to install Ruby DBI module?

With this test code:

#!/usr/bin/ruby -w
   # simple.rb - simple MySQL script using Ruby DBI module

   require "dbi"

   begin
     # connect to the MySQL server
     dbh = DBI.connect("DBI:Mysql:test:localhost", "testuser", 
"testpass")
     # get server version string and display it
     row = dbh.select_one("SELECT VERSION()")
     puts "Server version: " + row[0]
   rescue DBI::DatabaseError => e
     puts "An error occurred"
     puts "Error code: #{e.err}"
     puts "Error message: #{e.errstr}"
   ensure
     # disconnect from server
     dbh.disconnect if dbh
   end


I get this error



c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:329:in `load_driver': Unable to 
load driver 'Mysql' (DBI::InterfaceError)
  from c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:227:in `_get_full_driver'
  from c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:213:in `connect'
  from mysqltest.rb:8
-- 
Posted via http://www.ruby-forum.com/.