[fpc-pascal]MySQL under Windows

[Michael Van Canneyt]

On Fri, 26 Jul 2002, Mirek Novak wrote:

> 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

I have the mysql 3.23 headers translated. I sent it to several people,
asking whether they would inform me whether it works OK for them.
I have had 1 reply.

I will commit the 3.23 version to cvs, and hope everything works.

Michael.