I don't know much about disconnecting problem but I know you dont need to set transaction every time ,just this line work for others automatically : SQLConnection1.Transaction:=SQLTransaction1;
About disconnecting you can make procedure that reconnect to DB when it disconnected or put a timer and check connection some times and if it was disconnected or other problem try to reconnect and put a counter so if MariaDB gone away for always,turn your auto connect system to off. Regards, Ara -- http://www.fastmail.com - Access all of your messages and folders wherever you are -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
