A friend was asking how I got mysql and ruby working together in windows. The notes below describe one attempt to use the mysql gem, but I never got everything working smoothly. In the end, I switched to use the MySQL ODBC driver. Then I could simply create an odbc connection to mysql, and call mysql through odbc.
(old notes from trying to fix this error)
getting past mysql errors
load_driver error
first removed dbi from ruby/lib/...
also made sure mysql gem is not installed: gem uninstall mysql
checked gem folder and found mysql folders i needed to delete
downloaded dbi from ruby forge
installed using:
ruby setup.rb config --with=dbi,dbd_odbc,dbd_mysql
ruby setup.rb setup
ruby setup.rb install
installed mysql gem:
gem install mysql
selected most recent from list (2.7.3)
