Using odb database

ninersfan · Newbie Joined: 27 Sep 2010 Posts: 3

Hi,
I recently downloaded openoffice. I used to use a microsoft access database.
Now i want to add the openoffice databse (.odb) to the SYSTEM DSN tab in ODBC data source administrator. How can i do that (as there is no option to add a .odb database).
Thanks!

pitonyak · Posted: Mon Sep 27, 2010 12:47 pm Post subject:

I do not think that you can easily add an OOo database using an ODBC driver.

http://www.oooforum.org/forum/viewtopic.phtml?t=51147

sorry
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php

ninersfan · Newbie Joined: 27 Sep 2010 Posts: 3

Thanks pitonyak,
any idea on how i can create and use a database in this manner without microsoft acess?

pitonyak · Posted: Mon Sep 27, 2010 1:22 pm Post subject:

You can certainly use another database product such as

MySQL
http://en.wikipedia.org/wiki/MySQL

or

PostGREs
http://en.wikipedia.org/wiki/PostgreSQL

You can use OOo Base as a front end if you desire, and, you can obtain an ODBC driver for access.
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php

ninersfan · Newbie Joined: 27 Sep 2010 Posts: 3

Ill try that.
Thanks again