Connecting to mysql 5.1 with Ubuntu 10.04 Lazarus
lazarus / 16-Databases

----------------------------------------------------------------------
jaggerdan · 2010-10-30 12:37

I have searched hi and low on how to do this.  I've tried the
suggestions elsewhere on this forum to no avail.  There HAS to be a
way to easily connect to mysql 5.1    Check this out 
http://bugs.freepascal.org/view.php?id=17406    Michael Van Canneyt
(administrator)  has something here but I can't get it to work.  He
uses the standard sqldb components instead of zeoslib.  Maybe someone
with more experience with FPC can post details on how to do it.

----------------------------------------------------------------------
bdexterholland · 2010-11-10 16:25

Well, he said that's not possible.

----------------------------------------------------------------------
Lacak2 · 2010-11-11 04:11

Try download latest snapshot, bug is already fixed (at least in 2.5
branch), so it should work now.

----------------------------------------------------------------------
danilo666 · 2010-11-11 10:06

I made this conection with lazarus downloading the package manager, I
downloaded the Dlls and mysql client, I used Lampp like server of
mysql.

I hope help you.

----------------------------------------------------------------------
jaggerdan · 2010-11-14 14:14

Quote from: Lacak2 on November 11, 2010, 05:11:10 amTry download
latest snapshot, bug is already fixed (at least in 2.5 branch), so it
should work now.

Thank you, could you provide more details how to do this?

----------------------------------------------------------------------
jaggerdan · 2010-11-14 14:17

Quote from: danilo666 on November 11, 2010, 11:06:19 amI made this
conection with lazarus downloading the package manager, I downloaded
the Dlls and mysql client, I used Lampp like server of mysql.

I hope help you.

Thank you for your reply.  I think you are using windows version.  I
am using linux ubuntu.

----------------------------------------------------------------------
Lacak2 · 2010-11-15 04:39

Quote from: jaggerdan on November 14, 2010, 03:14:09 pmQuote from:
Lacak2 on November 11, 2010, 05:11:10 amTry download latest snapshot,
bug is already fixed (at least in 2.5 branch), so it should work now.

Thank you, could you provide more details how to do this?

Download and install from
ftp://www.hu.freepascal.org/pub/lazarus/snapshots/
-or-
http://www.hu.freepascal.org/lazarus/

look for 2.5.1 or 2.4.3 versin of FPC (I am not sure if it is fixed
also in 2.4 branch, so you must try)

----------------------------------------------------------------------
jaggerdan · 2010-11-20 13:48

Quote from: Lacak2 on November 15, 2010, 05:39:34 amQuote from:
jaggerdan on November 14, 2010, 03:14:09 pmQuote from: Lacak2 on
November 11, 2010, 05:11:10 amTry download latest snapshot, bug is
already fixed (at least in 2.5 branch), so it should work now.

Thank you, could you provide more details how to do this?

Download and install from
ftp://www.hu.freepascal.org/pub/lazarus/snapshots/
-or-
http://www.hu.freepascal.org/lazarus/

look for 2.5.1 or 2.4.3 versin of FPC (I am not sure if it is fixed
also in 2.4 branch, so you must try)

Thank you Lacak2,
I have the snapshot of 2.5.1 (fpc-2.5.1.i386-linux.tar.gz) but i am
unsure what to do with it.  Could you please provide details on how to
update to this version? I am using Lazarus 9.28.2.  Any help would be
greatly appreciated

----------------------------------------------------------------------
Lacak2 · 2010-11-22 03:59

I am not very familiar with Linux (I am using Lazarus/FPC only under
Windows and there is prebuild package, which can be downloaded from
above mentioned ftp site).
I think, that you must set in Lazarus Environment/Options paths to FPC
2.5.1 directories ... may be, someone other can be more precise.

----------------------------------------------------------------------
bdexterholland · 2011-02-03 13:15

On last december, I've connected to MySQL 5.1 using libmysql.dll from
MySQL 5.0.

----------------------------------------------------------------------
marcov · 2011-02-03 13:49

Quote from: Lacak2 on November 15, 2010, 05:39:34 am
look for 2.5.1 or 2.4.3 versin of FPC (I am not sure if it is fixed
also in 2.4 branch, so you must try)

No, only since yesterday. 

btw
For Zeos, you must derive your own connection helper (some interface)
for 5.1 iirc.
But I know this only from monitoring forums, I use postgres.