Remember ODBC MySQL Password

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Remember ODBC MySQL Password

Postby lachieg » 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
Open Office Base 4.1.1 on Windows XP and 7
lachieg
 
Posts: 1
Joined: Mon Jul 13, 2015 8:32 am

Re: Remember ODBC MySQL Password

Postby Villeroy » 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   Expand viewCollapse view
oDS = ThisComponent.DataSource
oDS.User = "Edward Snowden"
oDS.Password = "T0p_S3cr3t"
ThisComponent.store()
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24657
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 2 guests