Connect to OpenOffice Database from C#

0
votes

I am using Open office database and want to connect data from table in C#, I used connection string "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\work\HP_Data.odb", but at the run time shows an error "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine".

1
c#databasehsqldbopenoffice-base

1 Answers

0
votes

I doubt that your approach is going to work, even if you do manage to get the Jet.OLEDB driver properly registered on your machine. The Jet.OLEDB driver is for connecting to Jet (Access) .mdb files, not OpenOffice .odb files.

I believe that OpenOffice Base uses the HSQLDB database engine, so you may be able to connect to your .odb file from C# using an HSQLDB driver.