MySQL Library functions
MySQL Error: 9999
Can't load libmySQL.dll from directory C:\Users\user\AppData\Roaming\mysql-demo\libmysql.dll
I am on Windows 7 Home premium, serv pack 1, 64-bit
I'm using Autohotkey v.1.1.19.02.
Anyone figure it out, or have any suggestions for troubleshooting? Please?
The file exists at C:\Users\user\AppData\Roaming\mysql-demo\libmysql.dll, so why can't it load it? Is there an updated dll file?
more info:
well, I google searched for libmysql.dll, found http://dev.mysql.com...ds/connector/c/, and downloaded and installed the latest mysql connector dll package, found the libmysql.dll file in that folder subtree, copied it to my C:\Users\user\AppData\Roaming\mysql-demo\ folder, and tried again. Now it pauses for a few seconds, like it's trying to connect, but comes back with an error message in what looks like hyroglyphics- error #2005. I'll try to look that up now and troubleshoot some more...
Ah, well for one thing, it seems the free mysql db i found online does not allow remote connections to it. Too bad. Guess I'll look for another.
hi there
i had same issues and you have to compile your ahk before running, then run the compiled exe file
remember to put libmysql. dll in script working directory while compiling
look here for more info http://ahkscript.org...c.php?f=6&t=429
When I try to run I get 9999 error.
Cant load libmySQL.dll from directory
Please help
Hi, Panofish, thank you for this work.
I'm stuck at the very beginning of my script.
I've a MySQL database to which I access using HeidiSQL as shown in this screen:
Therefore I guess my script to access that database should be something like this:
mysql := new mysql db := mysql.connect("127.0.0.1", "root", "ascent") if db = ExitApp } sql = ( SELECT level FROM characters.characters WHERE name = "Felia" ) level := mysql.query(db, sql) MsgBox % level
Hi, Panofish, thank you for this work.
I'm stuck at the very beginning of my script.
I've a MySQL database to which I access using HeidiSQL as shown in this screen:
Therefore I guess my script to access that database should be something like this:
mysql := new mysql db := mysql.connect("127.0.0.1", "root", "ascent") if db = ExitApp sql = ( SELECT level FROM characters WHERE name = "Foo" ) level := mysql.query(db, sql) MsgBox % level
When I run it, however, db is an empty variable because I get the following error:
Any help?