you can also just use odbc - the instructions on the kite bird site will show you how, but you will also need the mysql odbc driver. google will know where that is.
Paul ----- Original Message ----- From: Adam Reed <[EMAIL PROTECTED]> Date: Tuesday, March 20, 2007 2:49 pm Subject: Re: [Wtr-general] Watir / Ruby / Mysql > Paul, > I don't think this is the same gem you loaded, but for my own > use of a similar setup, I use Ruby DBI: > > Usage: http://www.kitebird.com/articles/ruby-dbi.html > Download: http://rubyforge.org/projects/ruby-dbi/ > > Hope that helps, > Adam > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Paul Hammer > Sent: Tuesday, March 20, 2007 3:07 PM > To: [email protected] > Subject: [Wtr-general] Watir / Ruby / Mysql > > > I've been using Ruby with Watir for a few months now to scrape > data off > of internal web pages where I work. I'm fairly happy with the > results,although I want to improve these processes. I want to put > this data > into mysql (yes, I've designed a schema). > > On a windows box, I have Watir running with Ruby, and I have mysql > running stand alone. I've used this command to load the mysql > interface: > > gem install mysql > > and this seemed to complete fine. Then I used this statement to > try and > connect from ruby to mysql: > > dbh = Mysql.real_connect("localhost", "root", "mysql", "test") > > and I got this message: > > Error code: 1251 > Error message: Client does not support authentication protocol > requested by server; consider > upgrading MySQL client > > What am I missing? > > Paul > > _________________________________________________________________ > Get a FREE Web site, company branded e-mail and more from Microsoft > Office Live! > http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/ > > _______________________________________________ > Wtr-general mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/wtr-general > _______________________________________________ > Wtr-general mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/wtr-general > _______________________________________________ Wtr-general mailing list [email protected] http://rubyforge.org/mailman/listinfo/wtr-general
