Tuesday, October 29, 2013

Installing MicroOlap for Postgres under WINE on Linux

MicroOlap.com provide a great commercial CASE tool for working with postgres databases. I've been using the software happily since 2006. Since then, I've painstakingly evaluated many different competing opensource and commercial products but have yet to find a product that matches MicroOlap for features, ease of use and robustness.

The software  isn't available in a Linux version, however it does run seamlessly under WINE. As a pre-requisite to installing MicroOlap under WINE you need to install jet40 and mdac28 via winetricks, as documented here: https://www.microolap.com/products/database/mssql-designer/help/Introduction/WineConfiguration.htm

$sh winetricks jet40 mdac28

For a 32 bit OS that is all that is required, however on a 64 bit OS you will get the following error reported:
jet40 install completed, but installed file /home/USER/.wine/dosdevices/c:/Program Files (x86)/Common Files/Microsoft Shared/dao/dao360.dll not found

The "missing" dao360.dll is however available under the /home/USER/.wine/dosdevices/c:/Program Files/Common Files/Microsoft Shared/dao/ directory.

The trick is simply to create a shortcut in the Program Files(x86) path to the dll in the  Program Files path, as follows and then to try the winetricks command again (you may also have to create the dao folder under the Program Files(x86) path first):
$sudo ln -sf /home/USER/.wine/dosdevices/c:/Program\ Files/Common\ Files/Microsoft\ Shared/dao/dao360.dll /home/USER/.wine/dosdevices/c:/Program\ Files\ (x86)/Common\ Files/Microsoft\ Shared/dao/dao360.dll

Lastly, if you are by any chance behind an authenticated proxy, you will need to first set the http_proxy environment variable, before running winetricks, as follows:
$http_proxy=http://user:password@proxy_ip_address:proxy_port
$export http_proxy

Saturday, October 26, 2013

http://register.gongride.org.au/2013-Sydney-to-Gong-Bike-Ride/skilly/&utm_source=individual&utm_medium=Widget&utm_campaign=

I'm doing the Gong again next week. The ride is in aid of MS Australia. If anyone wants to part with their hard earned cash, they can donate to the cause via my page below:

http://register.gongride.org.au/2013-Sydney-to-Gong-Bike-Ride/skilly/&utm_source=individual&utm_medium=Widget&utm_campaign=