Zeoslib Portal

I have written a db app using Delphi 10.4 Community and Zeos db components, client server using MySQL 8.0.27 server. I have this app running on 5 computers as clients on the same local network. The issue is: I have set up a new computer which I set up identical to the other clients, but when I try t...

Jan, thanks much. That was it. I had not compiled the Zeos components with 64bit setting in IDE. After some struggling, got it compiled and all the search paths fixed.

Thanks again!
Doug

So I have Delphi 10.4 app using Zeos DB components compiled as 32bit app, working fine. I now want to compile to 64 bit to avoid the libmysql.dll 32bit issue - MySQL not supporting 32 bit any longer. When I try to compile to 64 bit, I get an error, Unit 'ZAbstractRODataset' not found. I don't get th...

Thanks for the replies! AE - Transaction isolation on the ZConnection is set to none - I presume the default. marsupilami - AutoCommit was set to false! Setting it to True, now the grid updates the DB! Phew! Thanks so much! Must have clicked that off in testing, trying to click on something else. An...

I've run into a problem with DBGrid and ZQuery. I'm running Delphi 10.4.2. I have an application using TDBGrid, TDataSource, TZQuery, and TZConnection using a MySQL 8.0 DB. All works great, except I can't get changes made through the DBGrid to update the DB. I have another routine in code which inse...

Sorry guys for my venting. I was getting frustrated and it showed through. Its the age old thing of people who know the technology are not the best to write the documentation. They can easily assume too much. I've fallen in that trap so many times. I have tried to remain user focused throughout my c...

THANK YOU! Michal, Jan and AE for your insight! It was the MySQL root user - Limit to Hosts Matching = localhost that was preventing me from accessing from another machine. I just made a new user and assigned it wildcard % for Host Matching. Presto. Thanks again for your help. Zeos components are wo...

I am using Delphi 10.4 Community addition, and Zeos 7.2.14. Have written a simple app which I can connect to a MySQL on my same development computer. But when I run this app from another computer with valid hostName = IP address of the dev computer, I get a "SQL Error: Access denied for user 'r...

Thanks AE. Ok, Thanks for the hint on the package name. But why is the 10.4 package labelled XE10.4? That is very confusing! Nowhere in Embarcadero do they use the designation XE10.4, that I have seen. I suggest that be changed pronto. "You have to open ZeosDbo.groupproj and compile the package...

Thank you Jan, I had not found the documentation which you linked. I see that you wrote it - thanks. But I have to disagree with your statement on page 8 - that "installing Zeos is not that complicated"! Maybe for you! First off, the instructions in the doc say to "Open the delphi pro...

I am really lost. I downloaded the Zeos 11.0 package from https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/branches/8.0-patches/packages/Delphi11/ . I tried to build or compiling each project and I get nothing but errors. Why is this so difficult? In Delphi 5, I was used to getting a component pac...

Thanks aeHimself. Ok, trying to find Zeos 8. Latest on main SourceForge Zeos link is 7.2.14.
Doug

Thanks for the reply and hints. I upgraded to 10.4 Sydney Community. Now I see that there really are no packages above DelphiXE10.4 - is that what I should be using? Thinking the DelphiXE is earlier version... Thanks!

Doug

Back to Delphi after some years away - last used Delphi 5. Using RAD Studio 10.1 Berlin - Community addition now. Downloaded zeosdbo-7.2.12-stable.zip. Unzipped contents. Trying to install this package using the following menu selections in Delphi - Components, Install Packages, Add, point to the do...