Twayne wrote:
Demet Acargil wrote:
Hello, I'm very interested in using OpenOffice.org, but I'd like to
know if it's possible to link Base files to MS VisualBasic6.0, like
an MSAccess Database file. Thank you in advance for your help.
Hello Demet,
Short answer - NO. There is not an ODBC or JDBC driver that will
directly connect to a Base file with an embedded data.
Longer answer - you can open a Base file with embedded data in a VB6
application using the OO.o API - you can execute statements and
retrieve OO.o result sets via the API. You can not connect these
result sets to VB data aware controls in the VB applications UI - you
would have to move the data into and out of those controls via your
own code and then use Update statements to write the data back.
Drew
VB6 SP6 can use SQL quite well, regardless of the creator.
That's true - the problem is getting a connection to the database.
There is available ( sorry I don't have the URL as I don't use it, I
believe the author is in France ) a utility that:
- opens a Base file and extracts the database files
- writes them to a temporary location
- launches an HSQLdb server instance connected to the files
You then use JDBC to connect to the server instance when you are all
done you call the utility again
-it shuts down the HSLQdb server
- writes the data files back into the Base file.
In this scenario you could use VB data aware controls.
--
OpenOffice.org User Community Forum: http://user.services.openoffice.org
United States PostgreSQL Association: http://www.postgresql.us/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
