title: Connect to PostgreSQL from libreoffice base with SDBC
body: <p>I'm trying to open a connection to a PostgreSQL database from LibreOffice with SDBC. After installing the "postrgre-sdbc-0.7.6" plugin, the "postgresql" datasource appears.
  The system asks for the datasource URL where I enter my IP </p>
  
  <pre><code>192.168.0.12
  </code></pre>
  
  <p>then my user name, ticks the "Password required" box, and after entering my password the "Test connection" button gives me the following error message.</p>
  
  <pre><code>A driver is not registered for the URL sdbc:postresql:192.168.0.12
  </code></pre>
  
  <p>I tried adding the port to the URL (192.168.0.12:5432), same error.
  As suggested I also rebooted both base and the computer, no luck either.</p>
  
  <p>I know the server is running correctly as I access it no problem from pgAdminIII with these parameters.</p>
  
  <p>As suggested by Richard, I also tried </p>
  
  <pre><code>host=192.168.0.12 port=5432 dbname=dataerp connect_timeout=10
  host=192.168.0.12 port=5432 dbname=dataerp 
  host=192.168.0.12 dbname=dataerp
  dbname=dataerp host=192.168.0.12
  </code></pre>
  
  <p>also</p>
  
  <pre><code>//192.168.0.12/dataerp
  //192.168.0.12:5432/dataerp
  192.168.0.12:5432:dataerp
  192.168.0.12:5432:dataerp:myusername:mypassword
  192.168.0.12:5432=dataerp
  </code></pre>
  
  <p>Nothing works, I still get the same error message
  Any help welcome!</p>
  
  <hr>
  
  <p>After investigations, I had installed the postgresql ODBC driver doing</p>
  
  <pre><code>sudo apt-get install odbc-postgresql
  </code></pre>
  
  <p>While what was needed was:</p>
  
  <pre><code>sudo apt-get install libreoffice-sdbc-postgresql
  </code></pre>
  
  <p>The correct connection syntax was </p>
  
  <pre><code>host=192.168.0.12 port=5432 dbname=dataerp 
  </code></pre>
  
  <p>Do not forget to reboot after this or it won't work!
  This tip was found <a href="http://adventurer.org.nz/?page=computing/narratives/2012-11-13_LibreOffice-Postgresql.txt" rel="nofollow">here</a></p>