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

[NoOp]

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
> 
> # 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.