Connecting to MySQL using Open Office Base via ODBC...

[Gabriel Dragffy]

The was a step that I missed out, see below:


On Sun, 2007-06-03 at 17:31 -0700, NoOp wrote:
> On 06/02/2007 10:29 PM, Gabriel Dragffy wrote:
> 
> > 
> > OK finally figured out how to do this without losing the menu items AND
> > not having to remove ubuntu OOo, or ubuntu-desktop. Here's what I did:
> > 
> > ###############################################################
> > Follow your instructions for getting OOo, converting to RPM etc:
> > 1) First, go to OpenOffice.org and download the latest version for
> > Linux. http://download.openoffice.org/2.2.0/index.html [NoOp note:
> > before downloading, uncheck the "Include the Java JRE with
> > this download"]
> > 2) Use Archive Manager or whatever and extract the file you downloaded into a directory.
> > 3) Change directory (cd) into the RPMS directory:
> > cd /where/you/extracted/openoffice/RPMS
> > 4) Let's go install alien, which converts the files in the RP
> > sudo apt-get install alien
> > sudo alien --scripts --keep-version *.rpm
> > ###############################################################
> > 
> > Now this is what I did differently:
> > # Backup the menu entries to somewhere, for example your /home:
> > sudo cp /usr/share/applications/ooo-* ~
> > 
> > # Then install the OOo debians that we have made, using the command you
> > # gave (when in the correct directory, natch):
> > sudo dpkg -i *.deb
> > 
> > # At this point we have two versions of OOo installed, and the menu
> > # entries have been deleted, not to worry:
> > 
> > # We'll divert the OOo provide by ubuntu to make room for the new one:
> > sudo dpkg-divert --divert /usr/bin/ooffice.ubuntu
> > --rename /usr/bin/ooffice


# Move the Ubuntu Oo binary
sudo mv /usr/bin/ooffice /usr/bin/ooffice.ubuntu

> > 
> > # Now we will link our new OOo to the old binary for the Ubuntu one:
> > sudo ln -s /opt/openoffice.org2.2/program/soffice /usr/bin/ooffice
> > 
> > # Need to make one more symlink:
> > cd /opt/openoffice.org2.2/program/
> > sudo ln -s soffice.bin ooffice.bin
> > 
> > # Now we can restore our menu entries:
> > sudo cp ~/ooo-* /usr/share/applications/
> > 
> > Now whenever we start the various OpenOffice programs it launches our
> > new version. The Ubuntu version is still installed and can still be
> > found by apt, so it will be very happy when it comes to updates and
> > upgrades. The only disadvantage that I can see is that you lose about
> > 200MB disc space having both versions installed.
> > Note:  This is what I did, but I wrote this after performing the
> > actions. Should work, but I haven't actually followed these letter by
> > letter myself.
> > 
> > 
> > 
> 
> Excellent! I have a machine that only has (U)OOo and StarOffice on it &
> I'll try the entire process later this evening. Perhaps if we can get it
> fine tuned we can make a simple wiki style set of instructions.
> 
> 

This way you can execute the new Oo by executing /usr/bin/ooffice, and
the ubuntu one using /usr/bin/ooffice.ubuntu

-- 
Gabriel Dragffy FdA BA(Hons)


Websites by Gabe:
http://dragffy.com
http://andrew-norman.com

On-line CV:
http://dragffy.com/gabescv