MySQL unable to load Foreign library

[valentin-grilli]

Hello,

I am currently trying to use your library which seems to be very useful for my project.

I am still a newbie in Lisp and when I try to install your library and try a connection I get this error:

Error: Unable to load foreign library (LIBMYSQLCLIENT). Could not register handle for external module LIBMYSQLCLIENT (file-name libmysql.dll): Le module spécifié est introuvable.

(MySQL-server is install)

Do you have any idea where this is coming from?

I am using Win 10 64bits on LispWork Pro

Thx for the future feedback

[fukamachi]

I'm a foreigner on Windows system, but did you install mysql-client, not only mysql-server?
Tell me the location of libmysqlclient.dll on your machine, then I can look into why it can't be found by cl-dbi.

[valentin-grilli]

i have both installed, but the .dll files is only present on the MySQL server one on the lib folder. Maybe u can show me in the installation of MySQL client how it's work ?

Thx a lot 😄

[nkhan-re]

I had the same problem, but providing the libmysql.dll in Windows\System32 allowed me to proceed. Late response, but in case you were still curious.