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

[NoOp]

On 06/03/2007 05:31 PM, 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
>> 
>> # 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.
> 
> 

I tested on the other machine starting from step 1 all the way through
your added instructions and it works perfectly. Thanks!-)