Apache OpenOffice (AOO) Bugzilla – Issue 104475
text/csv database documents are incompatible between OOo 3.1 and DEV300.m52 and later
Last modified: 2009-08-25 06:49:09 UTC
- in OOo 3.1: - File / New / Database - "Connect to an existing database", Type "Text" - on the second wizard page, point to an arbitrary folder - finish the wizard, save the database document to an arbitrary location - in OOo DEV300.m52 and later - open the database document you created above - select "Tables" on the left hand side => an error message pops up saying: SQL Status: HY000 The connection to the external data source could not be established. No SDBC driver was found for the given URL. Also note that in the status bar of the database application window, no database type/details are shown.
fs->oj: In .odb files created with m51 and before, the media-type in the content.xml file is "text/csv", in m52 and later, it is "application/csv" ...?
Already fixed in cws dba32e
As workaround for a m52 or later search for a file named flat.xcu in your OOo installation and in that file search for application/csv and replace it with text/csv . That should do it.
Closing it.