[libreoffice-users] Re: Connecting to Existing PostgreSQL Database Table

Le 14/11/11 19:28, Rich Shepard a écrit :

Hi Rich,


>   When I try File -> New -> Database -> connect to existing database, I've
> no idea what to specify with either jdbc or odbc. Pointers greatly
> appreciated.

If you have the libreoffice-sdbc-postgresql connector installed,
available on Ubuntu-based distributions (not sure about others), then
you should see a postgresql entry in your list of existing connection
possibilities.

There was a problem with writing to the database with this native
driver, it has been worked on by a developer in the past few months, but
I don't think the corrections have been integrated into the master
source code repository of the Libreoffice project yet.

If you do not have the native postgresql driver, then you can use JDBC,
but you have to use the JDBC3 postgresql driver, and performance is
well, below par, for anything but a very small and uncomplex datatabase.

In the archives of this mailing list, I have already written how to
setup a JDBC connection to a postgres db.

Alex


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted