Installing Firebird RDBMS Win32 and OBDC under PuppyLinux

This how to was written by Jerry Park DO on the 16th Feb 2008

HOW TO INSTALL FIREBIRD WITH NATIVE WINDOWS ODBC USING WINE ON PUPPY LINUX 3.0.1

-----------------------REQUIRED FILES---------------------------------

Puppy Linux 3.0.1     URL:   http://www.puppylinux.com/download/downpage.htm
    download "puppy-3.01-seamonkey.iso" and burn to CD

wine-0.9.55-i486-1kjz.tgz     
    URL:  http://sourceforge.net/project/showf...?group_id=6241
    use Slackware package
    convert to "wine-0.9.55-i486-1kjz.pet" using utility tgz2pet on Puppy Linux
    This is the format of Puppy Linux's package manager.

winetricks
    linux shell script - launches a GUI - 
    URL:   www.kegel.com/wine/winetricks

mdac_typ.exe (this will be mdac 2.5 - use winetricks to obtain)

arial.exe (use winetricks to obtain)

Firebird_ODBC_2.0.0-Win32.exe   
     URL:  http://www.ibphoenix.com/downloads/?C=S;O=A
        or  http://www.firebirdsql.org/index.php?op=files&id=odbc
     This can also be obtained from the synapse-server.exe installer GUI

Firebird-2.0.1.12855-1-Win32.exe  
     URL: http://www.firebirdsql.org/index.php...&id=engine_201


----------------------------------------------------------------------------

1.  Boot Puppy Linux 3.0.1 live CD. 
        Use boot parameter "puppy pfix=ram"
        you will be prompted to save to a personal storage file later
        when you reboot or shutdown.

2.  After successfully booting, run the Internet connecton wizard from the
        desktop icon "Setup"  - easy to connect with DHCP

3.  Use the ROX-Filer file manager.  Click on the file
        wine-0.9.55-i486-1kjz.pet.  Follow installer.  The following
        dependencies will be missing--ignore these:
             libldap_r.2.3.so.0
             libesd.so.0
             libgphoto.2.so.2
             libgphoto2_port.so.0

4.  Use a console, type "winecfg".  The wine configuration GUI will launch
         and auto creates the wine file stucture in /root/.wine.  Exit.

5.  Obtain the shell script "winetricks" and save as ASCII. 
         Make it executable.

6.  Launch winetricks, and click on the following buttons (serially):
         gdiplus
         fakeie
         winver-nt40
         native_odbc
         volnum=

7.  Use winetricks buttons to download the following:
         mdac25
         ariel

         These will be saved in a folder "winetrickscache" in the same
         directory where winetricks is located.

8.  Go to the winetrickscache folder.  Open a console. 
         Type "wine arial.exe" to install the arial font. 
         Type "wine mdac_typ.exe" to install mdac 2.5.  The installer will run
         and hang.  Do a "Ctrl+C" and exit.  Go to
         /root/.wine/drive_c/windows/temp/IXP000.tmp folder.
         run "wine setup.exe" to finish running the installer.  It should not
         hang this time.  If a message box says mdac 2.5 has already been
         installed, use winetricks and click the winver-nt40 button again.
         This should fix the problem, and try running "wine setup.exe" again.

9.  At this point you can verify that the ODBC Data Source Administrator is
         working by typing in a console "wine odbcad32.exe"

10. Check to make sure the ODBC Data Source Administrator has been added to
         the wine control panel by typing in a console "wine control"
         to launch.

11. Now from a console, "wine Firebird_ODBC_2.0.0-Win32.exe" to install the
         Firebird ODBC driver.  Should install smoothly.  Follow prompts.
         You can now use the ODBC Data Source Administrator GUI to add the
         Firebird/Interbase(r) ODBC driver.

12. Add the Firebird RDBMS system.  From a console:
         "wine Firebird-2.0.1.12855-1-Win32.exe"  Follow the prompts.
         Settings should be:
             --Use the Guardian to control the server
             --Run as an application
             --Start Firebird automatically upon bootup
             --Install control panel applet
             --Generate GDS32.dll for legacy app support.
         This should install smoothly - no hanging or crashing.

13.  You can now use the ODBC Data Source Administrator to connect to a
         Firebird database(of the form XXXXX.FDB) and test the connection.