12 April 2014: The OpenOffice Wiki is not, and never was, affected by the heartbleed bug. Users' passwords are safe and wiki users do not need take any actions.

Base/connectivity/PostgreSQL

From Apache OpenOffice Wiki
Jump to: navigation, search

Connecting to a Postgresql Database

Using the SDBC Driver


Download the SDBC driver from PostgreSQL SDBC Driver This page has additional information on the driver.

Installation with OOo 2.x

DO NOT unzip the driver.

  • Go to menu bar
  • Open Tools/Extension Manager


ExtMgr.jpg

  • Highlight My Extensions
  • Click on Add... Button
  • Go to folder where SDBC driver was downloaded
  • Click Open
  • Make sure that it is enabled
  • Close extension manager
  • Shutdown OOo including the Quick Starter. You might have to use Task Manager in order to shutdown soffice.bin


  • Start OOo Base
  • The Database Wizard window will open up
  • Select Database...


DbWizard1.jpg

Note: Your Postgresql database must already exist.

  • Click on Connect to existing database radio button
  • Scroll down to postgresql
  • Click Next>>
  • Connection Setting...


DbWizard2.jpg

  • In the text box type: dbname=NameOfDatbase host=localhost. NameOfDatabase is the name of the Postgresql database that you are connecting to and use localhost if the Postgresql server is on your computer.
  • Click Next>>
  • Set up user authentication...


DbWizard3.jpg

  • Enter user name of Postgresql database
  • Click Test Connection


DbWizard4.jpg

  • Type in database password and click OK
  • If test connection is successful click OK
  • Click Next>>


DbWizard5.jpg

  • Click Finish
  • Type in OOo Base file name for this front end to your Postgresql database


Personal tools