Hello everyone I'm doing a little research and I can not find anything relating to this topic so here I am.
Is it possible to connect to an OpenOffice database through powershell either through the innate powershell cmdlets available or through an external snapin available for download? I'm looking for an alternative to SQL, MySQL or MS Access for people with no budget for extra software.
Any input would be appreciated!
Connecting to a Base database via Powershell
Connecting to a Base database via Powershell
OpenOffice 3.2 on Windows XP
Re: Connecting to a Base database via Powershell
No, you can not connect from outside. Mainly because there is no such thing as a "Base database", secondly because the type of database backend you can wrap into a Base frontend is a HyperSQL database.
If you separate the HSQLDB backend from the Base frontend you can connect to that backend from Base, MS Access, scripts, web-sites and many other frontend tools. Same with any other free backend such as MySQL, H2, PostgreSQL, ...
If you separate the HSQLDB backend from the Base frontend you can connect to that backend from Base, MS Access, scripts, web-sites and many other frontend tools. Same with any other free backend such as MySQL, H2, PostgreSQL, ...
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice