The mysterious problem of "Unknown MySQL data type!&quo

[whitewolf]

When I create, configure and activate ZConnection, he work fine. But if I try to activate or get data from my MySQL database with ZTable or ZQuery controls, appear the message "Unknown MySQL data type!". I try practically everything to solve this problem, unsuccessfully.

I am using Mandriva Linux 2010.0 x86_64 with Kernel 2.6.31.6-1mdv, MySQL Server 5.1.40, FPC 2.2.4, Lazarus 0.9.28.2 beta.

The ZConnection protocol I'm using is mysql5.

Please someone help!

Thank's.

[mdaems]

Hi whitewolf,

The only missing information is the zeoslib version you're using.
As far as I know this mysterious problem was solved by making zeoslib (at least partially) 64-bit compatible. Mysql, FB and postgres drivers should work, as far as I know. But there's only snapshots available from trunk and testing branch. So the official stable version is NOT 64-bit compatible.

Mark

[whitewolf]

Sorry for my ignorance.

I thought that if Zeoslib were compiled in an 64 bit enviroment by Lazarus, he worked fine.

How can I know if Zeoslib supports this architecture in future versions? Is there a prediction for this?

PS: My ZeosLib version is 6.6.5.

PS 2: Sorry for my bad english. :-)

[mdaems]

How can I know if Zeoslib supports this architecture in future versions? Is there a prediction for this?

Only prediction I can give : if people want to help in development and bugfixing there will be future versions.
Have a look at the TESTING or TRUNK versions in http://zeosdownload.firmos.at/downloads/snapshots/ . These are the 7.x previews which should be 64-bit ready. And if they are not, please let us know how you would fix it. If the patch is acceptable (which means "doesn't break 32 bit") it certainly gets merged into the official version. If it is not immeadiately acceptable, I'm sure the other 64-bit users will help us find a better solution for your problem.

Mark