James Elliott - WA Rural Computers wrote:
When I click on the filename, it does load and open, defaulting to the
forms screen. However when I click on the Tables icon I get a pop-up
error message, which when expanded out says:
-------------------------------
Error:
The connection to the data source "WARC" could not be established.
Error:
SQL Status: HY000
The connection to the external data source could not be established.
No SDBC driver was found for the given URL.
Information:
A connection for the following URL was requested: sdbc:embedded:hsqldb
------------------------------
I have created several tables and have been back several times to add
new tables and/or edit the existing ones, as this is a
work-in-progress. At the moment it looks like all my work has been
flushed down the drain.
I am using OOo 2.3 running under Windows XP SP2.
If any of you can suggest how I might get my tables back, I would be
much obliged.
Many thanks, James.
Hi James,
Well, it is doubtful that the tables and the data therein is actually
'flushed'- a little out of reach for the moment.
The error message usually ( pretty much always ) is telling you that
there is a configuration problem, not that there is any corruption in
the data files. ( as an aside, although it is not impossible, most often
when there is a data corruption problem most of the data can still be
retrieved by diving into the actual file structure - but I doubt you
will need to do that here )
First - did you change anything on your system of late. Specifically
adding the stand alone version of HSQLdb - that can happen by the way
when installing other packages as it is a fairly common engine. Did you
install any reporting tools for instance?
Seconding - did you make any changes to your java configuration. In
2.3.0 and 2.3.1 IIRCC adding hasldb.jar to your class path, explicitly,
will make the use of the internal database fail - while at the same time
allowing you to connect to a HSQLdb engine running in server mode via
JDBC. In fact it was an either or situation - setup to connect to the
server model and you could not connect embedded, change to work embedded
and it did not work with the external JDBC driver. The Issue can be
found at http://qa.openoffice.org/issues/show_bug.cgi?id=82222
Not sure that is it for you however, as the error message is different -
but perhaps.
Anyway - first things first. What happens if you work with a different
Base file - or if you try to create a new one, same error or no error?
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]