Issues creating MySql Plugin on Windows

[NicholasSmith]

Good morning everyone,

I've been having some problems getting the MySql plugin up and running on Windows after trying both the suggestions listed on the wiki page here, and also the recommended guide on the Trolltech site. I'm using the Open Source version of Qt SDK 2009.02 and MySQL v5.0, when using 2009.01 it would create the necessary files in the plugin folder, but never load them, and with 2009.02 it just doesn't seem to be able to create them at all.

Has anyone else run across this? If so has anyone found anyway to get around it?

EDIT:

I rolled back to 2009.01, which does create the necessary files (qmysql.dll etc), I've cleared the plugin cache with regedit several times, rebooted a few times and still no joy. I'm half tempted to just install a fresh version of XP with just Qt and Mysql and see if that works

[wysota]

What exactly did you do and what does QSqlDatabase::drivers() return? Did you remember about compiling the driver in the same mode (debug/release) as your Qt libraries? Do you have a QApplication or QCoreApplication object created before trying to access the database? This is the place where plugins are loaded into Qt.

[NicholasSmith]

I completely forgot to mark this as done, it turned out to be the stupidest error in the world in the end.

I already had a version of libmysql.dll in my windows32 path, and even though I'd set C:\Mysql\bin as the first directory in PATH to be checked it was using the older version, I dumped the newer version into windows32 and it worked.