Member Avatar for MARKAND911

What will be the connection string for OpenOffice Base (.odb) database? i want to use this connection string in C#. Which namespace needed to be added to use .odb operations?

  • 3 Contributors
  • 4 Replies
  • 863 Views
  • 3 Months Discussion Span
  • Latest Post Latest Post by PsaltyDS
Member Avatar for MARKAND911

thanks about the link. but that link dont give information about the connection string

Member Avatar for kvprajapati

Text from http://dba.openoffice.org/

Starting as mere database access functionality of the other OpenOffice.org applications, Base has, with OpenOffice.org 2, evolved to an own database application. It allows you to access data on an external database of your choice (for instance MySQL, PostgreSQL, and many others), plus bundles the HSQLDB database engine, this way allowing you to kick-start with your own database.

Take a look at - Base New Driver tutorial.

Member Avatar for PsaltyDS

Text from http://dba.openoffice.org/

Starting as mere database access functionality of the other OpenOffice.org applications, Base has, with OpenOffice.org 2, evolved to an own database application. It allows you to access data on an external database of your choice (for instance MySQL, PostgreSQL, and many others), plus bundles the HSQLDB database engine, this way allowing you to kick-start with your own database.

Take a look at - Base New Driver tutorial.

Unfortunately that just repeats more information about connecting FROM OpenOfice Base TO other databases.

I am also looking for ADO or ODBC connectivity TO an OpenOffice Base (ver 3.x) database FROM other apps. OpenOffice uses HSQL, as you posted, but the HSQLDB site itself only references a single attempt by one of their Devs to create an ODBC driver, which isn't even at first Alpha stage as far as I can find. The OpenOffice sites don't mention it all (again, as far as I can find).

So far, it looks like you can't get there from here.

:(

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.