无法加载供应商库libmysql.dll或libmysqld.dll [英] cannot load vendor library libmysql.dll or libmysqld.dll

问题描述

我想在delphi xe10和fireDAC中使用MYSQL。
所以，表单上的FDConnection，然后输入关于我的mysql db的基本信息。

但是当我尝试连接时，有一个错误
无法加载供应商库libmysql.dll或libmysqld.dll

我读了embaradeco手册，我试过
1.将libMySQL.dll复制到我的 c：\program files（x86）\Embarcadero\\\bin：fail（这意味着无法加载数据库数据，仍然会报错）
2.在FDDrivers.ini中指定路径
[MySQL] VendorLib = \libmysql.dll：fail

所以，我很好奇我还要检查什么。必须有我错过的东西。
任何人都可以帮助？

解决方案

我自己解决了这个问题。

我得到了提示
http://chapmanworld.com/2015/01/18/connecting-radstudio-to-mysql-with-firedac/

首先，我应该知道有32位dll和64位dll分别。
我使用64位dll，并得到错误。所以，我使用32位dll
我从 http://dev.mysql.com/获取文件下载/ mysql /

将它复制到程序文件（x86）/Embarcadero/Studio/17.0/bin
然后获得成功消息。 / p>

此外，mariaDB也可以正常工作。

**注意
在链接中， t推荐复制文件到... / bin目录。但我的情况，我觉得很好，直到现在。

I want to use MYSQL in delphi xe10 with fireDAC. So, FDConnection on the form, then input basic information about my mysql db.

But when I try to connect, there is an error "cannot load vendor library libmysql.dll or libmysqld.dll"

I read embaradeco manual and I have been tried 1. copy libMySQL.dll to my "c:\program files (x86)\Embarcadero\Studio\\bin" : fail(That means cannot load db data, still got error) 2. specify path in FDDrivers.ini [MySQL] VendorLib=\libmysql.dll :fail

So, I'm curious what else I have to check. There must be something I missed. Anyone can help?

解决方案

I solved this problem myself.

I got hint from here http://chapmanworld.com/2015/01/18/connecting-radstudio-to-mysql-with-firedac/

First, I should know there are 32bit dll and 64bit dll separately. I used 64bit dll and got error. So, I use 32bit dll I got files from http://dev.mysql.com/downloads/mysql/

Copy it to Program Files(x86)/Embarcadero/Studio/17.0/bin then I got success message.

Additionally, mariaDB also works fine.

**CAUTION In the link, Author doesn't recommend copy file to .../bin directory. But My case, I feel fine till now.

这篇关于无法加载供应商库libmysql.dll或libmysqld.dll的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！