errors with MySQL 5.0.77

I have updated Rails to 2.2.2 and then found I had to update MySQL to
work with the mysql gem. However, I’ve found that with MySQL 5.0.77, I
get this error:

LoadError (126: The specified module could not be found. -

Google search suggested removing the but that didn’t fix the
problem. However, downgrading MySQL to version 5.0.18 (the version I had
running on a development PC that wasn’t getting an error) fixed the

Another thread:

Suggests problems with MySQL 5.0.27. It looks to me that the mysql gem
on Windows systems is very dependant on MySQL version.

OS Windows 2003 server.