MySQL component info
lazarus / 16-Databases

----------------------------------------------------------------------
Middlecope · 2012-03-08 00:48

MariaDB 5.2.9
Lazarus 2.9.31
FPC 2.4.4

I repeated  The programs in the ~/fpc/packages/mysql and they work! At
least I can connect and do SELECT Q's
It worked with libmysqlclient.so.16 and with libmariadbclient.so (easy
to change)
I tried MySQL51Connection to connect.  and it tells me that version
5.1 does not work with client 5.5.
Unfortunately The 51Con is hidden in the SQLDB..lpk.
Ca anybody give me a hint where I can find the source where the
MySQL51con.lpk is hidden???
Than I can try to change it a little bit and let it work.
Thanks Teunis

----------------------------------------------------------------------
Middlecope · 2012-03-09 01:13

Partly SOLVED
In my try-out project directory I copied
~/fpc/packages/mysql/src/mysql51.pp
~/fpc/packages/fcl-db/src/sqld/mysql51conn.pp
(of course with the appropriate *.inc)
I compiled all files. One change made in mysqlconn.inc
VB := StrToBCD(Src);
          {changed could not find FSQLFormatSettings }
          {VB := StrToBCD(Src, FSQLFormatSettings);}  Suggestions
welcome
Unfortunately I can't use the properties in the MySQL51Connection1. I
have to do it at runtime.
Queries Transactions DataSource and DBGrid worked as expected.
My conclusion is MySQL51Connection can connect to MaraiDB 5.2
Until now libmysqlclient.so.16 can be used or the
libmariadbclient.so.? can be used
Any hints for updating the MySQL51Conn component in SQLDBlaz.lpk  (or
instruction how to compile it)?
If I find something myself I will put it in this thread
Thanks Teunis

----------------------------------------------------------------------
Middlecope · 2012-03-13 21:52

For a (partial) solution see my post:
"How to get rid of the VersionMismatch warning"

----------------------------------------------------------------------
BigChimp · 2012-03-14 08:44

Thanks Teunis for documenting your findings... even though you seem to
be talking to yourself in this thread, you will at least have helped
other people that search through the forum posts...