On Wed, 2012-01-04 at 19:09 +0100, Michael Parchet wrote: > Hi, > > I'm a developer and I'm looking for to a driver to connect to a open > office database with an API (application programming interface) for > developer
Well, reading a bit into your question I would say the answer is - You don't do that. In other words the Base database document (.odb) is really just a wrapper around, amongst other objectys, the properties for a connection object to a data storage engine. In all cases but one, an embedded HSQLdb database, this connection is realized by an external resource - a normal ODBC/JDBC or vendor specific driver. So, in all those cases, but the one, you could connect to the same data store using an ODBC/JBDC or vendor connector from your code, as you would without regard to OpenOffice. With regard to the HSQLdb database storage embedded in an .odb file, there is no separate driver currently available to access same, short of running an instance of entire OpenOffce.org application in order use the OO.o API to get at the data. There are a couple of work around techniques that folks have used - a script floating around that, for instance, extracts the HSQldb schema/data from an .odb and then starts up an instance of the HSQLdb engine - of there is a counterpart function to pack the data back into the original ODB file after your down using it. (I don't a reference to that script off hand, btw - I believe it was published by a community member in France shortly after version 2.0 shipped) Best wishes, //drew > > Tanks for your help > > Best regards and happy new year. > > mparchet > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
