Subject Re: Connection string in ADODatabase
From Akshat Kapoor <akshat.kapoor@kapoorsons.in>
Date Thu, 22 Oct 2020 15:59:06 +0530
Newsgroups dbase.getting-started
Attachment(s) connection string parameters final.pdf

Good afternoon Gaetano,
> finally, you can use the above either in a form/report by dropping it on
> the designer surface, just be aware that the connection to the server
> will time-out, so in a form, you may need to reactivate the connection
> before using the ADOQUERY objects because you cannot control when the
> user will click the button, example:
>
> //reestablish database connection
> form.adodatabase1.active=null
> form.adodatabase1.active=true

On a local network using MariaDB 10.3/10.4 I have not faced this issue.

You need to set the options value to include option of autoreconnect.

For internet i cannot say.

Regards
Akshat