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 best solutions below
Related Questions in SQL
- Can MVC.NET prevent SQL-injection at razor or controller level?
- SQL server not returning all rows
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Creating a parametrized field name for a SELECT clause
- Combine two rows based on common ID
- Column displays each count
- Slick query for one to optional one (zero or one) relationship
- Aggregate and count in PostgreSQL
- MAX and GROUP BY - SQL
- SQL statement for a tricky 2 table query
- How to create nested selects with sql?
- Pull and push data from and into sql databases using Excel VBA without pasting the data in Excel sheets
- Best Practice for adding columns to a Table in Oracle database
- SQL FIFO STACK using two tables
- SQL Query - Order by String (which contains number and chars)
Related Questions in COMMAND-LINE
- How can I pass variable to ansible playbook in the command line?
- Find all files contained into directory named
- How to add documentation or comment in RakeFile
- Setting the place Python Looks for Files in CMD
- How to run ".iim" file with Google Chrome from commandline?
- Modify Control C Command Signal to Allow Input
- How to create a new file where each new line contains some text and quoted line/step number?
- Create text file using echo in command prompt
- Command line arguments are not passed in Windows 7 - Java
- does a publicly available partial solution exist to parse *nix-style command line options without pre-knowledge of the keys?
- How to call getPackageManager() from Android command-line executable
- Compare 2 text files and display the difference between them (PowerShell or CMD)
- PsExec returning "the system cannot find the file specified"
- What is the difference between "echo" and "echo -n"?
- How do I fix this error? Registry key 'Software\JavaSoft\Java Runtime Environment'\CurrentVersion'?
Related Questions in CYGWIN
- How to add directories to Cygwin gcc default search path
- Cygwin failing to open .git/config
- What is the meaning of environment variable !::=::\
- Error in Dired sorting on Windows (with Cygwin Emacs)
- Eclipse not recognizing CygWin gcc
- Getting gcloud to work in Cygwin Windows
- Facing issue while listing file contents in cygwin
- Error while installing HBase on windows
- How do i change the modification/creation date of a folder
- Relationship between gcc, g++, cygwin, and wingw?
- Linking error with LAPACK under cygwin
- Error loading D:\cygdrive\d\path\to\my\file.pdf
- Unable to connect to SSH after generated public key and private key
- wget not displaying all website data
- How to run pyinstaller correctly on cygwin?
Related Questions in HSQLDB
- Why throwing java.lang.IndexOutOfBoundsException when reading blob in the database hsqldb
- Caused by: org.hsqldb.HsqlException: cardinality violation
- When I use hsqldb I have problems with GUI (JavaFx)
- HSQL (in-memory) dramatically slows down when database grows
- Strange results with HSQL (memory) when running transactional test
- HSQL upgrade to 1.8: ... DEFAULT 'NaN' changed to ... DEFAULT 0E0/0E0 in database.script causes HsqlException: unexpected token / in HSQL 2.3.2
- How to integrate Kettle with H2
- Is it possible to use OracleDataSource for some other database except for Oracle?
- HSQLDB: Switching between testing database and production database
- TomEE in Eclipse always uses HSQL Database Engine instead of defined in persistence.xml (EclipseLink)
- thread-weaver with hibernate unit testing
- What embedded database to use for seamless MySQL > (embedded database) dumping
- How to know max size for hsqldb in-memory database
- is it possible connecting to a POSTGRES database through HSQLDB
- HSQLDB: How to truncate the database after testing?
Related Questions in OPENOFFICE-BASE
- OpenOffice Base 4.0.1 Printing a right aligned field
- How to make LibreOffice Base reconnect to a database
- How to access openoffice.org database from command line
- OODB Update with Aggregate Function
- Convert doc into pdf
- Open mdb app using Openoffice 4.0.1
- Transfer a data set from openoffice base to calc
- OpenOffice Base - Merge >200 tables into one
- Is it possible to create a parameter query in openoffice base?
- database structure with multiple bank statements
- Reset button in Openoffice base
- OpenOffice Base LIKE with columns
- Visual basic 2010 to open office base
- Open Office Base: How to Create a INSERT Trigger
- What is wrong with this SQL command for Apache Open Office Base?
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)
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?
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: