Topic: MySQL problem - Invalid access to memory location
I'm having a problem running rails with MySQL.
Here's my setup:
OS WinXP SP2
When I try to build a simple rails app and navigate to a page, I get an "Invalid access to memory location" error. I tried a simple activerecord script:
:adapter => "mysql",
:host => "localhost",
:username => "root",
:password => "root",
:database => "simple_db")
class Account < ActiveRecord::Base
account = Account.new
account.username = "test"
When I run it I get this error:
!!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql.
C:/ruby/ruby-1.8.6/lib/ruby/gems/1.8/gems/mysql-2.7.3-x86-mswin32/ext/mysql.so: 998: Invalid access to memory location. - C:/ruby/ruby-1.8.6/lib/ruby/gems/1.8/gems/mysql-2.7.3-x86-mswin3
I tried "gem install mysql", but this doesn't change anything.
I read on one post that I should add %mysql_home%/bin/libmySQL.dll to %ruby_home%/bin. I tried this, but still no luck.
Any other suggestions?