Re: OpenOffice and Postgres 7.3.2

Start by opening OO and clicking on Tools->Options-Security. Under Security
there will be box labeled class path. You can enter the path to the jar file
there. Once you back out of there press F4 to get the Data Source Browser.
Right click on the Bibliography data source. Then click on Adminstrate Data
Sources. Click on New Data Source. In the right panel select JDBC as database
type. Move to JDBC tab enter org.postgresql.Driver as JDBC driver class.
Enter postgresql:database as URL (assuming database on localhost and using
default port).Select Apply and your data source should be set up. In the left
panel navigate the data source tree to get to tables. Open a table. In the
right panel will be table contents. At bottom of panel there will be record
navigation arrows (next record.last record,etc). There is also a star shaped
icon. If this icon is yellow data entry is allowed, if it is grayed out then
the table is read only. Hope this helps.

On Monday 17 March 2003 01:08 am, Dave Cramer wrote:
> Adrian,
>
> Can you tell me how to recreate this problem. I am OpenOffice
> challenged.
>
> Dave
>
> On Sun, 2003-03-16 at 22:02, Adrian Klaver wrote:
> > Programs used;
> > OpenOffice 1.01
> > SuSE 8.1
> > Java 1.3.1
> > Postgres 7.3.2
> > I compiled the JDBC driver from the source included with Postgresql 7.3.2
> > and I set up OpenOffice to use the driver. The problem is that while I
> > can open and move through the tables I do not have write capabilities.
> > The tables have primary keys and the driver sees them. Any help would be
> > greatly appreciated.
> >
> > Thank you
> > Adrian Klaver
> > aklaver(at)attbi(dot)com
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org