Connecting to a Base database via Powershell

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
rpeare
Posts: 1
Joined: Tue Feb 19, 2013 4:31 pm

Connecting to a Base database via Powershell

Post by rpeare »

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!
OpenOffice 3.2 on Windows XP
User avatar
Villeroy
Volunteer
Posts: 31345
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Connecting to a Base database via Powershell

Post by Villeroy »

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, ...
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
Post Reply