Hi All,
I'm trying to connect to a remote mySQL server with Lazarus from OSX, but I can't get it to work...
Here is what I did:
New project with only a TSQLDBLibraryLoader, TMySQL55Connection and a TSQLTransaction.
I first tried this on Windows with the proper libmysql.dll to be sure I can connect to the DB.
On OSX, I load the libmysqlclient.18.dylib in the TSQLDBLibraryLoader, put the ConnectionType to MySQL 5.5 and tried to enable... Success !
After this succes, 2 problems immerge:
- If I set the Connected property of TMySQL55Connection to true during design time I get the following error:
Cannot load default MySQL library ( "libmysqlclient.dylib.18" or " libmysqlclient.dylib"). Check your installation.
Notice the reverse order of 18 and dylib in the message as to the filename
- When I do this at runtime, I get a different error:
TMySQL55Connection can not work with the installed MySQL client version: Expected (5.5), got (6.1.6).
In fact the library libmysqlclient.18.dylib comes from the MySQL connector 6.1.6, but as I read somewhere, it should not report its version as 6.1.6 but as 5.5 as set in the ConnectionType property of the TSQLDBLibraryLoader.
The first error isn't a big deal, as long the program works at runtime, so it's really the second error that is puzzling me the most...
I should note that installing MySQL on the OSX machine isn't an option as the final program has to run on third party machines through a simple installation (which will be my next question when I'll get the above working...).
This is the configuration I'm using:
Lazarus 1.4.4
FPC 2.6.4
i386-darwin-carbon
OSX 10.11.1 El Capitan
Thanks for any input,
Frank.