1044 access denied error after upgrade

[neilld]

Just upgraded from 7.1.4 to 7.2.4 and my previously working app has stopped.
I've tracked it down to the mySQL database name being all in capitals. Looking at the SQL monitor output, it generates a SHOW TABLES FROM statement and at that point, converts the database name into lower case, resulting in an error.
Connecting to an identical database with a name consisting of upper and lower case characters works fine.

[marsupilami]

Hello,

what is your environment? Which Delphi version do you use or which Lazarus version? And are you on Linux or Windows?

Could you please check, wether that also happen with the current patches version of Zeos 7.2 where we fixed some bugs lke this one? See here: https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/.
Please check the branches/7.2-patches branch.

Best regards,

Jan

[neilld]

Hi. Thanks for your reply.
I'm using Delphi 7 and accessing an online mySQL 5 database. The database is called EPF (in capitals).
Worked fine in the same environment using 7.1.4.
I'll see if I can figure out how to download and install the patches and see if it makes any difference.
Neill.

[marsupilami]

Hello Neill,

do you know if that database is run on Windows or Linux? Some rules of how database objects are treated in MySQL depend on the OS - eg. database EPF is the same as database epf on Windows but on Linux that would be different databases?

Best regards,

Jan

[neilld]

Hi Jan.
It's almost certainly Linux hosted.
Thanks,
Neill.

[mwinter]

Hi,
I am facing the sam problem.
Did you find any solution?
Thanks
Michael

[marsupilami]

Hello Michael,

are you using the current Zeos 7.2.6 version?

Best regards,

Jan

[Germano]

I have the same problem.
My hosted base: Linux
Base name: MYBASE (uppercase)
IDE: Delphi 2007
Zeos: 7.6.2.1-Stable (updated files similar to Patches-7.2)

By Delphi in design time it works correctly, however connecting by .exe (after compiled) Zeos changes the base name to: mybase (lowercase).
Can you help, please?