Forum: Ruby mysql-ruby module errors

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

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?

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

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