Apache OpenOffice Community Forum

Posted: **Mon Jul 13, 2015 8:34 am**

Is it possible to have Open Office Base remember the username and password for a MySQL ODBC Connection?

Thanks,
Lachie

Posted: **Mon Jul 13, 2015 9:43 am**

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

oDS = ThisComponent.DataSource
oDS.User = "Edward Snowden"
oDS.Password = "T0p_S3cr3t"
ThisComponent.store()

Apache OpenOffice Community Forum

Remember ODBC MySQL Password

Remember ODBC MySQL Password

Re: Remember ODBC MySQL Password