Ask Your Question
1

How to Connect base to to PostgreSQL? [closed]

asked 2013-06-05 19:48:27 +0200

cootcraig gravatar image

updated 2015-11-02 02:58:21 +0200

Alex Kemp gravatar image

Version 4.0.3.3 (Build ID: 400m0(Build:3)) Ubuntu 13.04

I have a local PostgreSQL server running. I want to connect LibreOffice base to a PostgreSQL database. I do not see a native SDBC option, there is a JDBC option. How can I enable the SDBC interface? Do I need to use JDBC?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-02 02:58:35.669156

Comments

It's easy - see here. This is a very old article, but it works today.

JohnSUN gravatar imageJohnSUN ( 2013-06-06 09:19:03 +0200 )edit

I have this working now. Two things I had to fix; 1) sudo apt-get install libreoffice-sdbc-postgresql. PostgreSQL is now an option. 2) PostgreSQL 9.1 creates new users with an expired expiration date. I changed the expiration date. Now the connection works.

cootcraig gravatar imagecootcraig ( 2013-06-06 17:21:31 +0200 )edit

2 Answers

Sort by » oldest newest most voted
2

answered 2013-06-06 17:28:51 +0200

cootcraig gravatar image

I have this working now. Two things I had to fix;

1) sudo apt-get install libreoffice-sdbc-postgresql. PostgreSQL is now an option.

2) PostgreSQL 9.1 creates new users with an expired expiration date. I changed the expiration date. Now the connection works.

edit flag offensive delete link more
0

answered 2013-06-07 17:47:32 +0200

cootcraig gravatar image

I've now switched to using the JDBC PostgreSQL driver.

postgresql-9.2-1002.jdbc4.jar

I used.

connection string: postgresql:dbname

driver class: org.postgresql.Driver

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-06-05 19:48:27 +0200

Seen: 19,715 times

Last updated: Jun 07 '13