mysql-ruby module errors

[Mer Gilmartin]

Im trying to install mysql-ruby on windows 2000.
I thought version 2.7.1 installed properly
even when I got a failed installation of 2.7.0

the command I used was "gem install mysql".

That seemed to work perfectly so I
ran a mysql-ruby test program from
http://www.kitebird.com/articles/ruby-mysql.html.

I was thrown this ruby error. Does this mean that Mysql.2.7.1 didnt
install properly either?

ruby simple.rb

C:/ruby/lib/ruby/gems/1.8/gems/mysql-2.7.1-mswin32/ext/mysql.so: 126:
The specified module could not be found.
-c:/ruby/lib/ruby/gems/1.8/gems/mysql-2.7.1-mswin32/ext/mysql.so
<LoadError>
from

c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:33:in
'require' from simple.rb1

 

[Mer Gilmartin]

I also should mention a window pops up after running the command

ruby simple.rb

the window says

ruby.exe - Unable to Locate Component.

this application has failed to start because LIBMYSQL.dll was not found.
Re-installing the application may fix this problem.


Does that help any more with what this problem is?
What should I do?

 

[Nick Curry]

You probably figured this out by now, but for those that are having the
same problem, this is caused by the libmysql.dll not being on your path.
Essentially, that means that you have to make sure that the DLL is on
your path before running ruby, for example:

set PATH=%PATH%;c:\progra~1\mysql50\lib\opt;c:\progra~1\mysql50\include;
ruby script.server

If you are running 64bit MySQL and 32bit Ruby, you will need to download
the 32-bit libmysql.dll from mysql.com (e.g. by downloading the 32bit
MySQL zip package) and set the path to point to that.

Cheers,
Nick

 

[Mer Gilmartin]

My fix was reinstalling a few times till I got everything working.