Linux databases part 2

[Larry Hartman]

On Monday 18 June 2007 09:12:19 am Neil Winchurst wrote:
> On Mon, 18 Jun 2007 07:59:05 -0400
>
> Larry Hartman <larryhartman50 at bellsouth.net> wrote:
> > On Monday 18 June 2007 03:23:41 am Neil Winchurst wrote:
> > > On Sun, 17 Jun 2007 19:52:00 -0500
> > >
> > > <manchicken at notsosoft.net> wrote:
> > > > Have you tried open office base? Works great for me in this case.
> > >
> > > Yes, I have tried. I can't get it to work, so I have given up on it.
> > > Perhaps its me.
> > >
> > > Neil Winchurst
> >
> > Don't want to toot my horn here...I am new to databases, recently setup a
> > mysql database with a port from Open Office Base into Mysql.  Didn't
> > appear to difficult....I think I can recreate the effort if you are
> > interested.
>
> I have mysql running with knoda as a front-end. It is working well so
> far, but I need to learn more about hk_classes.
>
> As for Base, I think it depends which version. I have OO v 2.0.4. The
> wizard in Base does not work and I couldn't be bothered to pursue it.
>
> Neil

That could be it...I am at v2.2 on Feisty.  

I couldn't get a connection at first to MySQL from OO Base wizardry, so I went 
to Synaptic and searched for ODBC/JDBC, found libmysql-java and installled.  
Afterwards I started up Open Office Writer, went to "tools" menu, 
opened "options", found the "Open Office.org Base" section in the navigator 
pane.  I then selected "connections" under this category and 
clicked "Connection pooling enabled" and changed all the "no" to "yes" for 
each entry.  I closed all windows, close Writer, then opened Base and was 
able to connect to the database I created in MySQL with the Base wizardry.

Someone here that is more familiar with Open Office Base and MySQL can 
probably tell me that I didn't need to do all of those steps.....like I said, 
I am new to the process.  It didn't work when I started, it worked when I was 
done.

Larry