With MYSQL_OPT_RECONNECT=1 provided code works like expected

2012/12/5 <[email protected]>

>
>
> On Wed, 5 Dec 2012, Andrey Smyntyna wrote:
>
>  Hello.
>>
>> I need some explanation of how to do persistent connection to MySQL
>> database and restore it if it has broken.
>>
>> In my test project I have created TMySQL51Connection component with
>> KeepConnection property set to True
>> and additionaly before making any database operations I check connection
>> availability like below:
>>
>>  if not dm.mysql.Connected then
>>      dm.mysql.Connected := True;
>>
>> But sometimes I anyway get connection error with the fact that MySQL
>> server
>> is present and available in network.
>>
>
> As far as I know, the 'Keepconnection' is not functional.
>
> Michael.
>
> --
> ______________________________**_________________
> Lazarus mailing list
> [email protected].**freepascal.org<[email protected]>
> http://lists.lazarus.**freepascal.org/mailman/**listinfo/lazarus<http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus>
>
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Reply via email to