I have a Lazarus App which I use heavily that uses a MySQL Database. I have an older 32 bit laptop (Running Fedora 12) that it still works on using Zeosdbo. I would consider moving this over to Postgresql, but I am running up against the same problem there too. Aparently, Lazarus is looking for libpq.so.4, while my implementations have libpq.so.5

Now I understand on the 32 bit version of Lazarus there is a TMysql51Conn in the SQLdb tab. Is this compilable on 64 bit machines? What steps would I have to do to add it to my Lazarus (0.9.30) implementation?

I saw a reference saying that by calling initialiseMysql, you could explicitly set what library to use. But I couldn't find any documentation on how to do this.

Thanks in Advance, TH

Aparently, Lazarus is looking for libpq.so.4, while my implementations have

libpq.so.5

It shouldn't be hardcoded AFAIK: libpq.so only, which may be a symlink to the correct version. Try checking the source code whether the .4 is hardcoded or not.

When I last looked at this (as, I stress a user) the relevant units were looking for libpq.so and I ended up creating symlinks as below.

/usr/lib/libpq.so -> libpq.so.5
/usr/lib/libpq.so.5 -> libpq.so.5.1
/usr/lib/libpq.so.5.1

FPC up to and including 2.4.4 still appears to look for the fixed name libpq.so. At some point after that it's gained the capability of using a user-specified name, but I don't yet know how that's set up from Lazarus.

I was wrong, Postgre does work. My Postgre config was messed up. I would though very much like to have MySQL working on the current versions.

TH