From: Curt Hibbs <curt@...>
Date: 2005-01-07T05:55:53+09:00
Subject: Re: MySQL DBD now working on my Windows XP box

Jim Menard wrote:
>
> I've been struggling with getting MySQL working on my work box
> running Windows
> XP. I installed DBI and DBD but kept seeing errors. Here are the
> two actions
> that finally got it running:
>
> 1) Downloaded mysql.so from
> http://seagecko.org/thoughts/2004/09/09/ruby-mysql-and-windows/ (thanks,
> Justin) and installed it in
> /ruby/lib/ruby/site_ruby/1.8/i386-msvcrt. That
> changed my error message to one that said something like "can't find
> mysql_character_code_somethingorother in LIBMYSQL.DLL".
>
> 2) Copied /mysql/lib/opt/libmysql.dll to /windows/system32, replacing the
> libmySQL.dll that was already there.
>
> Now I can use DBI and---even better---Rails on my work box. Yay!
> I hope these
> two tips help somebody else.

I'm not sure why you had to go to all that trouble... for me, I just
installed Ruby with te One-Click installer and them at the command line ran
"gem install rails" (which includes MySQL support). I can then use MySQL
with Rails -- no problem (I never tried DBI or DBD, though).

Curt