Unable To Connect Base to My PostgreSQL

CarlosinFL · General User Joined: 27 Sep 2010 Posts: 5

I am trying to connect Base to my PostgreSQL server and I downloaded and installed a plug-in however it doesn't appear to be working for some reason. I keep getting this error:

The connection to data source <name> could not be established.

No SDBC driver was found for the given URL.

I installed the 0.7.6b for Linux patch from here and it installed fine. I restarted Base and then under the database list I saw a new option for 'postgresql'. That is the one I selected and I keep getting the same error. Anyone know what's wrong?

r4zoli · Posted: Mon Sep 27, 2010 9:42 am Post subject:

0.7.6b is good only for coming OOo 3.3, for older versions use 0.7.6a, and works with 8.x versions of postgreSQL versions, not work with new 9.0 version.
You can use JDBC driver for 9.0.

CarlosinFL · General User Joined: 27 Sep 2010 Posts: 5

I removed the 0.7.6b & installed 0.7.6a from the same site and I don't appear to be using 9.0. I am using 8.4 right now and my version of OO Base is 3.2.

r4zoli · Posted: Mon Sep 27, 2010 8:53 pm Post subject:

Maybe your linux distribution repackaged this driver, you can download from repo with package manager. This is true for debian, ubuntu and opensuse if I know well.

CarlosinFL · General User Joined: 27 Sep 2010 Posts: 5

I didn't know my Linux workstation had to have a driver installed. What driver are you talking about? I thought I downloaded the driver from this link so why would I need to install something from my Debian or Ubuntu package manager? Is the plugin simply not enough?