I have a database built in openoffice.org base (.odb). I would like to open this database using a command line sql client, such as sqlite3 or psql. Can anyone tell me how to make this work? I am running Windows 7 64-bit and have cygwin installed.
How to access openoffice.org database from command line
1k views Asked by ewok At
1
There are 1 answers
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in COMMAND-LINE
- ZSH function parameters conundrum
- Parse command line arguments and write useful usage message without additional code
- Playwright JS: Getting an error when debugging using line numbers
- NPM Command Line Tool - Command not working
- How to get argument from Command line for my python package
- Send a json command to an app at a known port/address?
- Using command to open Privacy & Security > Proflies page
- Extract filepaths of .MP4 files in subfolders of main folder to textfile
- Does Mac OS have different Git versioning?
- Trouble Fetching Go Modules: Network Timeout When Accessing proxy.golang.org
- Why does command substitution work in these ways?
- Finding total RAM consumption of process, including swap
- When using the ripgrep command in the Terminal how can I search for files which contain one pattern AND another pattern?
- I can't use command "start" in git bash
- Executing a Jupyter Notebook from the Command Line with a Specified Kernel
Related Questions in CYGWIN
- "Config.guess failed to determine the host type" when trying build binutils-2.7 with Cygwin
- Installing the C compiler for LC3
- On cygwin I get errors containing -lintl and -liconv when running gcc
- Compile latest openssl with mingw64 within cygwin on Windows 11 vs install prefix path definition
- jq: C:/cygwin64/bin/jq.exe: error while loading shared libraries: ?: cannot open shared object
- I compiled LibreOffice on Windows using Cygwin, but after running 'C:/cygwin64/opt/lo/bin/make', I encountered numerous errors
- Install SoC EDS and create .o file using Cygwin
- What is ".cygwin" extension file? I can't get any result from Google&Bing SEs and file-ext.org
- Hive schematool Could not find or load main class PC"
- Scipy in Cygwin
- Error installing package in Octave Portable on Windows 10
- What is the latest version of Cygwin's Setup that will run in Windows 7?
- Issues with conda activate and deactivate in Cygwin
- Installing TreeTagger on Windows with Cygewin to use with Python
- SDL3 CMake linkage problem undefined reference for SDL
Related Questions in HSQLDB
- JDBC escape processing and HSQLDB regular expression syntax
- Spring Boot JPA (HSQLDB): INSERT using SELECT from data.sql, unexpected token: SELECT
- Showing Console of hsqldb as H2, Spring Boot 3
- How to drop all views in cascade manner from a schema in HSQL database
- HSQLDB script file formatting
- Type not found or user lacks privilege: TEXT
- Detection Issue of Default.theme File in Java Netbeans Platform Application
- create new record in db with sql
- Missing offset on OffsetDatetime on retrieval from DB
- How to fix the error: Caused by: java.lang.IllegalArgumentException: Not a managed type: class com.example.demo.data.MyObj?
- HyperSQL (hsqldb) compond statements in trigger failing
- HSQLDB timestamp fractional second parsing bug?
- SQL: help add secondary filter to chart query
- Java Spring, JPA, HSQLDB: schema created twice (rarely)
- HSQL Table refuses to update
Related Questions in OPENOFFICE-BASE
- How can I edit document like doc,PDF in my browser?
- Group two tables by month and make difference
- Simple Delete Command in SQL giving error message
- How to input Cell Value from OpenOffice Calc into AS400 textfield / screen using macros?
- Looking for OpenOffice base SQL reference
- How to fix :"Not Enough Stack Memory" when trying to load() with OfficeDatabaseDocument UNO service
- FB3.0 Dateadd() throws syntax error in where section of query
- Best way to run Macro on LibreOffice or OpenOffice SubForm "Fill parameters" Event
- What is wrong with this SQL command for Apache Open Office Base?
- OpenOffice Base - Merge >200 tables into one
- Open Java DB database in OpenOffice Base or Microsoft Access
- Execute SQL query from OpenOffice macro
- OpenOffice lost connection to MySQL on open cursor
- SQL OpenOffice Base "Not a Condition in Statement"
- Transfer a data set from openoffice base to calc
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
AFAIK you can't access the odb database directly, since it's an embedded db instance. But you can migrate the odb to a "normal" hsqldb database and run it in a HSQLDB server. After that, the database will be accessible using command line clients like SQLTool. You still can access that database from OpenOffice Base using JDBC, so you can continue using the data from OpenOffice as well as access it "from outside".
The odb is a zip file containing the standard hsqldb database files, so it shouldn't be too hard to make it available to hsqldb directly. There are some guides and tutorials how to proceed: