Page 1 of 1

Remember ODBC MySQL Password

PostPosted: Mon Jul 13, 2015 8:34 am
by lachieg
Is it possible to have Open Office Base remember the username and password for a MySQL ODBC Connection?

Thanks,
Lachie

Re: Remember ODBC MySQL Password

PostPosted: Mon Jul 13, 2015 9:43 am
by Villeroy
Yes, but then you could remove it from your MySQL-db as well. The password would be written into the Base document as clear text (XML).
This option is not implemented in the GUI but a simple macro can do the trick
Code: Select all   Expand viewCollapse view
oDS = ThisComponent.DataSource
oDS.User = "Edward Snowden"
oDS.Password = "T0p_S3cr3t"
ThisComponent.store()