search

fukamachi / cl-dbi

Database independent interface for Common Lisp
202 stars 28 forks source link

MySQL unable to load Foreign library #78

Open valentin-grilli opened 1 year ago

valentin-grilli commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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 commented 5 months ago

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.