Jump to content

Sky Slate Blueberry Blackcurrant Watermelon Strawberry Orange Banana Apple Emerald Chocolate
Photo

MySQL Library functions


  • Please log in to reply
66 replies to this topic
ztoddw
  • Members
  • 9 posts
  • Last active: Mar 02 2015 04:49 AM
  • Joined: 31 Jan 2015
I'm also getting this same error :

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.

TheGreatSardini
  • Members
  • 1 posts
  • Last active: Jun 08 2015 06:10 PM
  • Joined: 28 Aug 2014
I am having the same issue. can not load libmysql.dll
 
What I found is from what I can tell the libmysql.dll is corrupted or blank in some way.  Is Github deleting this? I have had several script break because the included dll files were blank or deleted. 
Does anyone have the old libmysql.dll file for this? I can't find it anywhere and all GitHub locations it is gone. or blank :p


taghi_ar
  • Members
  • 23 posts
  • Last active: Dec 29 2016 05:37 PM
  • Joined: 04 Nov 2014

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



newbieme
  • Members
  • 100 posts
  • Last active: Aug 07 2015 11:22 AM
  • Joined: 26 Mar 2014

When I try to run I get 9999 error.

Cant load libmySQL.dll from directory

Please help



bobycom
  • Members
  • 40 posts
  • Last active: Apr 14 2019 07:50 AM
  • Joined: 25 Mar 2014

If you are trying to use the latest version of the libmysql.dll on Windows XP machine, it will not work. Take a look in the new forum for possible solutions.



Cren
  • Members
  • 7 posts
  • Last active: Nov 04 2015 02:09 PM
  • Joined: 10 Oct 2015

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:

 

2172069d1446638386-new-var-img.png

 

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



Cren
  • Members
  • 7 posts
  • Last active: Nov 04 2015 02:09 PM
  • Joined: 10 Oct 2015

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:

 

2172069d1446638386-new-var-img.png

 

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:

2172073d1446638734-new-var-img1.png

 

Any help?