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.
I'm the author of that post.
If your IDE appears to vanish from time to time, with out warning or error message, it could be caused by placing that dll in your bin directory. Placing items there appears to trip part of the copy-protection mechanism in the IDE.
I work as technical support to the sales team at Embarcadero, and I can't count the number of times a customer has encountered this IDE vanishing problem, and it turned out a third-party component was installed in the bin directory. (May have been resolved since I posted that, but remains true for older versions at least)
