Cannot Load Libmysql.dll Error Code 193
Rocki Stenger
So I tried to use TFDPyhsMySQLDriverLink, I have set TFDPyhsMySQLLink.VendorLib to C:\Windows\System32\libmysql.dll, and set TFDConnection.DriverName to point to TFDPyhsMySQLLink.DriverID instead, but I got error dialog as displayed below.
I already put the libmysql.dll (32bit v5.6.15) into my Project folder, the EXE folder and C:\Windows\System32 folder (which is PATH location), but when I tried to Connect from the IDE, I encountered an error:
Mysql managed by WAMPserver64 on a 64-bit Window 10 machine. So I have libmysql.dll 64-bit located in my WAMP mysql bin folder. Downloaded mysql-connector-c-6.1.6-win32.zip from and put libmysql.dll 32-bit in SysWOW64, as suggested by NoName
Did you try to download the 7z archive and run the executable at Win64? It is not running on any machine. I did the VC2015 setup and set the VendorLib, too, but nothing changes. Win32 is ok, Win64 give the error:
[FireDAC][Phys][MySQL]-314. Cannot load vendor library [libmysql.dll]. The specified module could not be found. Check [libmysql.dll], which is located in one of the PATH directories or in application EXE directory.
If I start Delphi and create a new Windows VCL project, then choose Tools -> FireDAC Explorer, then try to expand the connection, I get an error "Cannot load vendor library [libmysql.dll, libmariadb or libmysqld.sll]"
I also found that when I compiled my PwrController.dll with CVI 2010, it gave me an error could not load PwrController.dll no matter what order the seqence calls were, leading me to believe that I am missing something when building this particular dll. As soon as I copy the original, developed and compiled in 2006, everything works again.
Do not download libmysql.dll from a "DLL download" website. There are many reasons why downloading a DLL file is a bad idea. If you need a copy of this file, it's best to obtain it from its original, legitimate source (Step 2 below).
Try your best to complete this step. This is the official source of the libmysql.dll file, so having one of those tools put a copy of the file on your computer is the best way to fix any errors regarding a missing libmysql.dll file.
All the information on your hard drive will be erased during a clean install. Make sure you've made the best attempt possible to fix the libmysql.dll error using a troubleshooting step prior to this one.
If you have verified that the libmysql.dll file is in your system path and you still get the above error, search your machine for all instances of the libmysql.dll file to make sure that another copy does not exist in a directory on the path.
OK, we have ported this thing to win7 know, was a pain in the ass, but now works great! Could not upload it to the code base though ... if somebody is interested, write me a pm ... i would like to share it!
Every time I get an error saying that the module was loaded but the DllRegisterServer was not found.In the program's help it is specified that libmysql.dll must be installed before connecting but doesn't say how and where.
Steve thanks.
I ran the library check and got mostly failures. The database I will be connecting to is not this server, so I don't have the MySQL libraries installed, no \MySQL Server5.7\lib..
HammerDB CLI v3.1
Copyright (C) 2003-2018 Steve Shaw
Type "help" for a list of commands
The xml is well-formed, applying configuration
hammerdb>librarycheck
Checking database library for Oracle
Oratcl_Init(): Failed loading oci.dll symbols with error 126Error: failed to load Oratcl -
Ensure that Oracle client libraries are installed and the location in the PATH environment variable
Checking database library for MSSQLServer
Success ... loaded library tclodbc for MSSQLServer
Checking database library for Db2
Error: failed to load db2tcl - couldn't load library "C:/Program Files/HammerDB-3.1/lib/db2tcl2.0.0/libdb2tcl.dll": this library or a dependent library could not be found in library path
Ensure that Db2 client libraries are installed and the location in the PATH environment variable
Checking database library for MySQL
Error: failed to load mysqltcl - couldn't load library "libmysqltcl.dll": this library or a dependent library could not be found in library path
Ensure that MySQL client libraries are installed and the location in the PATH environment variable
Checking database library for PostgreSQL
Error: failed to load Pgtcl - couldn't load library "C:/Program Files/HammerDB-3.1/lib/pgtcl2.1.1/libpgtcl.dll": this library or a dependent library could not be found in library path
Ensure that PostgreSQL client libraries are installed and the location in the PATH environment variable
Checking database library for Redis
Success ... loaded library redis for Redis
HammerDB CLI v3.1
Copyright (C) 2003-2018 Steve Shaw
Type "help" for a list of commands
The xml is well-formed, applying configuration
hammerdb>librarycheck
Checking database library for Oracle
Oratcl_Init(): Failed loading oci.dll symbols with error 126Error: failed to load Oratcl -
Ensure that Oracle client libraries are installed and the location in the PATH environment variable
Checking database library for MSSQLServer
Success ... loaded library tclodbc for MSSQLServer
Checking database library for Db2
Error: failed to load db2tcl - couldn't load library "C:/Program Files/HammerDB-3.1/lib/db2tcl2.0.0/libdb2tcl.dll": this library or a dependent library could not be found in library path
Ensure that Db2 client libraries are installed and the location in the PATH environment variable
Checking database library for MySQL
Error: failed to load mysqltcl - couldn't load library "libmysqltcl.dll": this library or a dependent library could not be found in library path
Ensure that MySQL client libraries are installed and the location in the PATH environment variable
Checking database library for PostgreSQL
Error: failed to load Pgtcl - couldn't load library "C:/Program Files/HammerDB-3.1/lib/pgtcl2.1.1/libpgtcl.dll": this library or a dependent library could not be found in library path
Ensure that PostgreSQL client libraries are installed and the location in the PATH environment variable
Checking database library for Redis
Success ... loaded library redis for Redis
So once you figure out that your missing the libmysql.dll you might try and grab the latest MYSQL C Connector from dev.mysql.com, they are up to version 6.0.2 at the time of writing this, you'll get the same error above. I was getting a more obscure crash before XE2 Update 1 which I didn't note down at the time, that abstract error message took me a while to figure out and was related to the libmysql.dll version.
It would be nice if embarcadero provided a location where you could download the compatible libmysql.dll files that work with dbexpress, it is worth noting that the XE2 read me does come with the following note :-
Dear Brett.I searched and "destroyed" all versions of libmysql.dll resident on my PC.The route used by RadPHP XE2, is the previously indicated (C: \ Program Files (x86) \ Embarcadero \ RadPHP \ 4.0 \ bin). Anyway, I put libmysql.dll (version 5.1.59) in the Windows path and in % SystemRoot% \ System32. I changed the environment variable "Path" to reflect the changes, but the error persists.Interestingly, when testing the connection works fine, but the error (DBX: Not supported) persists when try to show tables, procedures, etc.For now, I give up. I had never taken so long to set up a connection.Best regards.
I am having exact same problem as Enrique above, (DBX: Not supported). I can connect to a local instance of mySQL and browse tables with database manager, but for the remote instance it says "test succeeded" but when I try to browse tables it gives the above error. libmysql.dll is exact same version on my web server. DBX I am assuming is dbexpress. Does anyone know if there are additional files required on the webserver to work with a remote mysql connection? Win7 64 OS on desktop, all mysql 5.1.56 32bit on desktop and webserver. Any suggestions appreciated, ready to pull my hair out here, thanks.
(Exception TDBXError in module binario.exe at001797EA. Cannot load libmysql.dll library (error code 126). The libmysql.dll library may be missing from the system path or you may have an incompatible version of the library installed)
you should make sure libmysql.dll is installed on your computer, you can look for it under C:\Windows\System32 (in Windows 7, or the equivalent in other windows versions). This is specified in the php manual. You can download libmysql.dll here. This bug took me quite some time to solve. hope it helps.
Note: If when starting the web server an error similar to the following occurs: "Unable to load dynamic library './php_mysql.dll'", this is because php_mysql.dll and/or libmysql.dll cannot be found by the system.
MODULE: Unable to load mods\deathmatch\modules\mta_mysql.dll (126)
Hi!
Back in time, i uploaded my server in an archive to google drive. Now all of them are f#cked, i had to download nearly all of them again, and put them into the directory, where the corrupted dll-s were. Still it is not able to use this module. libmysql is in the correct place. I searched for error codes about this, i found nothing.
These are necessarily part of your software. If these are subject to the GPL, you would have to open source your software as well. If you cannot do that, you may have to acquire commercial licenses, or migrate to different libraries. The official MySQL connector is only available under the GPL, which doesn't work for you. Most of Qt is under LGPL which lets you use it from proprietary code (under some requirements), but some modules may be GPLv3 only.
What I'm finding is that even though the code fails because it is trying to insert a duplicate it doesn't come back with an error and an SQL error message. ( looking at @error and & _EzMySql_ErrMsg().
e2b47a7662