open office database connection
hi,
anybody know how to connect vb 6 to openoffice 2.0 databse.i need connction string.i know how to do it with access.as we are shifting from ms-access to openoffice database.
if somebody can give me link or good tutorial.
[245 byte] By [
ganesh4u] at [2007-11-11 7:33:44]
# 1 Re: open office database connection
I don't really know much about OpenOffice Base 2.0 but you need either an ODBC driver or OLEDB provider to work from Visual Basic. AFAIK, there are currently none available and Base can only be accessed from the OpenOffice apps.
# 2 Re: open office database connection
I'm not positive, but I believe you can in fact set up an ODBC source for Base.
Once Base is installed on your PC, go to Control Panel and double-click on "Data Sources (ODBC)" (XP users may need to switch to Classic View to see it.)
On the "System DSN" tab, click "Add" and see if there is an option for "Base" or OpenOffice database, or something similar.
There is a TON of info on the web about accessing ODBC adatbases through VB. Try Google or Yahoo.
-Andrew
