I remember having a whole load of trouble with it. Not sure if this will work but try it:

Remove the A6MySqld.dll and the libmysql.dll from your game folder and just have it in your Gamestudio6/AcknexPlugin folder. I think I had them both in the game folder and plugin folder but the moment I removed it from the game folder it started working.