Connection issues, continued...
lazarus / 16-Databases

----------------------------------------------------------------------
jksmithiii · 2025-01-16 21:02

win 10, trunk FPC. Tried everything to connect to Maria. She still
hates me. Checked for 64 bit libmysql.dll ('PE  d'), validated
connection params with HeidiSQL. Tracked down every libmysql.dll on
the drive. Heidi must have all the charm because she always connects.
So the connection issue has long been solved with that app. But still
this is a rolling grey issue with SQLdb.

So, moved over to Zeoslib. Connects right up. But the OPM version has
a bug in it that causes exception in the transaction code on app shut
down. May work if I did all the hookups manually in code instead of
using a data module. But instead of chasing that down, I tried to load
and install zcomponents.lpk direct from zeos github. No joy. Defines
issue around ASCII7_MESSAGES in zmessages.

Before I try all this on my Linux machine, I'd like to have a stiff
Manhattan right now, but I'm out of Makers. Anybody else out there
have this lead them to drink?

James

----------------------------------------------------------------------
jksmithiii · 2025-01-17 03:50

Ok, with some of these tasks, just saves time to not chase lpk issue
and wire it up manually. Works fine.

----------------------------------------------------------------------
TRon · 2025-01-17 11:03

Pouring your own drink always offers a finer grained control 

It tends to get complicated pretty fast with visual controls and all
the coupled events.

----------------------------------------------------------------------
Zvoni · 2025-01-17 11:48

Quote from: jksmithiii on January 16, 2025, 10:02:19 pmwin 10, trunk
FPC. Tried everything to connect to Maria. She still hates me. Checked
for 64 bit libmysql.dll ('PE  d'), validated connection params with
HeidiSQL. Tracked down every libmysql.dll on the drive. Heidi must
have all the charm because she always connects. So the connection
issue has long been solved with that app. But still this is a rolling
grey issue with SQLdb.

So, moved over to Zeoslib. Connects right up. But the OPM version has
a bug in it that causes exception in the transaction code on app shut
down. May work if I did all the hookups manually in code instead of
using a data module. But instead of chasing that down, I tried to load
and install zcomponents.lpk direct from zeos github. No joy. Defines
issue around ASCII7_MESSAGES in zmessages.

Before I try all this on my Linux machine, I'd like to have a stiff
Manhattan right now, but I'm out of Makers. Anybody else out there
have this lead them to drink?

James
... or in the future just quote the exact error-message you get.
With MariaDB it's 90% of cases the skiplibrarycheck-option

----------------------------------------------------------------------
CharlyTango · 2025-01-27 08:38

Quote from: jksmithiii on January 16, 2025, 10:02:19 pmwin 10, trunk
FPC.

Who would think of trying a database connection with a trunk version
without need?
It is not even guaranteed that trunk versions can be compiled at any
time without problems. And for me, ZEOS version 8 is still a long way
from being sufficiently tested in all aspects.

I would tackle something like this with a stable version, if necessary
even with one that is somewhat older and therefore sufficiently used
and tested (perhaps 3.4 or 3.6).
Version 7 of ZEOS, which has already been in use for a few years,
would also be suitable.

Such a strategy would drastically reduce your alcohol consumption, so
that in principle you would want to