Discovered that the problem here is that the datasource URL should be entered without the "jdbc:" prefix i.e.
hsqldb:file://D:/MyDBs/DB and not jdbc:hsqldb:file://D:/MyDBs/DB Have submitted an issue report as this is not made clear in OOo 2.0 beta. See http://qa.openoffice.org/issues/show_bug.cgi?id=45504 Thanks. Mark --- CPH wrote: > On Monday 07 March 2005 11:41, Mark wrote: > > I seem to be having problems using OOo 2.0 beta to > connect to an > > existing external HSQLDB. > > > > I have put the hsqldb.jar file on the Java class > path via OOo's "Tools | > > Options | Java" and then going to "File | New | > Database | connect to an > > existing source - JDBC". The data source url is > jdbc:hsqldb:file://D:/My > > DBs/DB (where DB is the name of the external > HSQLDB database). > > > > Using OOo to test the driver it confirms the > driver can be loaded. But > > when I try to connect to the database it says "The > connection to the > > external data source could not be established. An > unknown error > > occurred. The driver is probably defective". > However, the driver is not > > defective as I use it with other management > programs. I have tried the > > usual things like re-installing OOo. > > > > I really need to use the form based interface of > OOo to manage my > > existing database. > > > > Is anyone else having problems or anyone managed > to do what I am trying > > to do successfully? > > Mark, since this is OOo beta, maybe you should > download the l;atest beta and > if the problem still persists then ask on > [email protected] > > -- > CPH : openoffice.org contributor > > Maybe your question has been answered already? > http://user-faq.openoffice.org/#FAQ > Send instant messages to your online friends http://uk.messenger.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
