Andrew Douglas Pitonyak wrote:
Leonard T Greenland wrote:
I teach one course in which the students write a VB6 interface to
connect to a database. I have not been able to figure out how to
connect VB6 to the OpenOffice database.
OOo does not have an ODBC driver, so your only option would be to
connect to OOo using the UNO API and then directly manipulate the Base
document. If VB has some kind of form support with auto-fills using
ODBC drivers, you would not be able to do this.
You might want to consider using StarBasic and write your forms and
such from directly within OOo, because OOo does know how to directly
connect to a Base document.
I received the following note in the mail today:
JDBC connections to OO.Org databases are not directly supported,
however, OO.Org database files are nothing more than Zip files
containing HSQL data files. I wrote an article explaining how to connect
to OO.Org databases via JDBC using Java:
http://digiassn.blogspot.com/2006/07/java-creating-jdbc-connection-to.html
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]