MySQL and Zeoslib: None of the dynamic libraries can be found or not loadable (libmysql.dll) on Windows 8

mysql database delphi dll zeos
ThN picture ThN · Jan 21, 2015 · Viewed 8k times · Source

I am working with MySQL server and Zeoslib with Delphi. My program can remotely connect to the MySQL database but not locally. However, it keeps raising the following error - "None of the dynamic libraries can found or not loadable..."

enter image description here

So, I searched my system for the dll file. It is found within the MySQL library folder and MySQL Workbench folder. As suggested by other websites, I copied the libmysql.dll into my application folder. Still, my program keeps raising this NOT FOUND error on my windows 8 system. Any idea?

Update

  • 64Bit Test machine - 64Bit MySQL server, 32 Bit Application using 32bit Zeolibs component.
  • 32Bit Development machine - 32Bit MySQL server, 32Bit Application using 32Bit Zeoslib component.

Answer

ThN picture ThN · Jan 21, 2015

By simply copying libmysql.dll from 32Bit System and pasting it into 64bit system within the program folder, the program was able to connect to the database locally (localhost).

Related questions

Delphi XE5 FireDAC Error: Cannot load vendor library [libmysql.dll or libmysqld.dll]

I'm using Delphi XE5 on Windows 7 64bit and just trying FireDAC component. I'm using one TFDConnection component to connect to local MySQL database (v5.6.15). I already put the libmysql.dll (32bit v5.6.15) into my Project folder, the EXE folder and …

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More
How do I quickly rename a MySQL database (change schema name)?

The MySQL manual at MySQL covers this. Usually I just dump the database and reimport it with a new name. This is not an option for very big databases. Apparently RENAME {DATABASE | SCHEMA} db_name TO new_db_name; does …

Read More