Re: recover queries
Frank Schönheit - Sun Microsystems Germa ny <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
Hi Uwe, > On an old PC running Suse 7.2 and openoffice1.1.a I can't anymore open > the queries of a mysql database (with ODBC driver), every time I > intend to do so OO crashes. Is the data source already connected at this time? I.e., is the "Tables" node already expanded? If not, then the crash might happen upon connecting, and not upon opening the query, which might give hints for the reasons. Is it only when you open the queries for data display, or also when you try to open them for design? > It seems impossible to install a more > recent version of OO, so I would like to know whether it is possible > to recover these queries in any form. I think these queries are stored > in > $prefix/user/registry/data/org/openoffice/Office Add DataAccess.xcu to this path. > Could I just copy that directory and try to use it on a different PC > with 1.1.4 OO installed. Might work. However, this file contains more than the queries. If in doubt, or if copying the complete file doesn't work, open the file in a text editor, search for "queries", and manually copy the query strings. Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -