Adam & Paul, Thanks for responding. I was just reading the prerequisites section for the Ruby DBI, and it says:
"...you'll need to have both the Ruby MySQL module and the C API installed." Can you tell me where I can find these packages? Paul >From: Paul Rogers <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: [email protected] >Subject: Re: [Wtr-general] Watir / Ruby / Mysql >Date: Tue, 20 Mar 2007 16:13:16 -0600 > >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 _________________________________________________________________ Interest Rates near 39yr lows! $430,000 Mortgage for $1,399/mo - Calculate new payment http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-18466&moid=7581 _______________________________________________ Wtr-general mailing list [email protected] http://rubyforge.org/mailman/listinfo/wtr-general
