[fpc-pascal]MySQL under Windows

[Mirek Novak]

Fernando Lozano wrote:
> Hi Mirek,
> 
> 
> 
>>As for MySQL units for FPC this is is long-lasting problem and 
>>solution may be found in archive of this 
>>list. I've (2 years ago) got the same problem as U. It was caused by 2 things
>>   1. library was written for client 3.21.* (this may changed)
> 
> 
> It looks like now it was built for 3.23.*. At least the libmysql.dll from 3.23.32 worked fine for me. :-)
> 
> But the FCL database classes still give me "Internal error". Can someone tell me if they are ready for use or if the test program I sent to the list contains some mistake?
> 
> 
> []s, Fernando Lozano
> 
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> http://lists.freepascal.org/mailman/listinfo/fpc-pascal
> 
> 

I took look at mysql.pp vs. mysql.h and at least main structure st_mysql differs!!!  - This can cause very strange errors like RTE 
in writeln etc. Ofcourse u can compile & run demo prog. distributed with sources. It runs because of small database and little 
number of iterations. Simply said each iteration causes small memory leak - more records read/written (more iterations) ~ more 
leaks >> more strange errors :o(. Try to write bigger test program without FCL, using only mysql unit and you'll see ...

mysql.pp - current from linux sources (should be same for win32) - as there in sources isn't mentionet ssl extension I think lib
            is for 3.22.*
mysql.h - 3.23.49

-- 
--
Mirek Novak
Anima Publishers
CMS development

http://www.auto.cz
http://www.formule1.cz

jabber:mirek at njs.netlab.cz
ISEEKYOU:1<one>9<four>9<nine>44<eight>
GEsEm:+420603807838