Connecting to a Base database via Powershell

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

Connecting to a Base database via Powershell

Postby rpeare » Tue Feb 19, 2013 4:34 pm

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
rpeare
 
Posts: 1
Joined: Tue Feb 19, 2013 4:31 pm

Re: Connecting to a Base database via Powershell

Postby Villeroy » Tue Feb 19, 2013 7:39 pm

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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27706
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 1 guest