From: Luis Lavena <luislavena@...>
Date: 2010-09-07T02:50:24+09:00
Subject: Re: Problems using the Mysql gem

On Sep 6, 6:27 am, Jim Burgess <jack.ze...@gmail.com> wrote:
> Hi,
>
> I'm using the mysql (2.8.1 x86-mingw32) gem and MySQL Server version
> 5.0.90 on Windows 7, 64 bit. I'm also using ruby 1.8.7.
>

Is MySQL installed in 64bits? Or is 32bits MySQL?

Please note that MySQL binary needs a 32bits version of MySQL 5.0
"libmysql.dll"

You can find more details about copying libmysql.dll or about
compiling MySQL gem for 5.1 in RubyInstaller tutorial page:

http://github.com/oneclick/rubyinstaller/wiki/Tutorials

> Can anyone give me a pointer as to what is going wrong?
> I have tried googling the error message, but with no luck.
> I have also read the documentation installed with the gem and as far as
> I can tell I am using the correct syntax.
>

It might be that you don't have 32bits libmysql.dll somewhere in the
PATH for Ruby to use.

Placing a 32bits libmysql.dll in Ruby bin directory should help.

--
Luis Lavena