<?xml version="1.0" encoding="iso-8859-1"?>
<!-- name="generator" content="pyblosxom/1.3.2 2/13/2006" -->
<!DOCTYPE rss PUBLIC "-//Netscape Communications//DTD RSS 0.91//EN" "http://my.netscape.com/publish/formats/rss-0.91.dtd">

<rss version="0.91">
<channel>
<title>Rustybear Blog  Mar 2007</title>
<link>http://www.rustybear.com/cgi-bin/pyblosxom.cgi</link>
<description>Rustybear Blog</description>
<language>en</language>
<item>
  <title>Accessing a PostgreSQL database from OpenOffice.org base under Debian.</title>
  <link>http://www.rustybear.com/cgi-bin/pyblosxom.cgi/database/openofficeconn.html</link>
  <description><![CDATA[
<pre>
Solution:
apt-get install unixodbc odbc-postgresql
# odbcinst -i -d -f /usr/share/psqlodbc/odbcinst.ini.template
$ cat /usr/share/doc/odbc-postgresql/examples/odbc.ini.template >> ~/.odbc.ini

   1. Set connection parameters in ~/.odbc.ini (username, password, host...)
   2. Check "Connect to an existing database" from the oobase Database Wizard, select ODBC, click on "Browse".

At this point your PostgreSQL database should be listed among the available data sources. 
</pre>

]]></description>
</item>

</channel>
</rss>
