Applying Patches to Sybase SQL Anywhere Version 5.0 or 5.5 and Dynamo

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

To upgrade your SQL Anywhere installation to the latest release, simply

obtain the latest patch file and apply it to your current installation.



Step 1.  Obtain the necessary patches

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

SQL Anywhere patches are available from the Internet.  


On the Internet point your browser to 

https://download.sybase.com/esd/sqlany.html and select the 

desired maintenance release.  


Determine which patch files you will need by using the following legend.

For standalone installations obtain the standalone patch for the operating 

system you have installed.  For client/server installations obtain the 

server patch for the operating system installed on the server, and client 

patches for operating systems installed on the client machines.



The Dynamo component is included with SQL Anywhere Professional Version 5.5  

patches and separately for SQL Server Professional for Windows NT customers. When 

patching SQL Anywhere Professional be sure to download one of the patches which 

includes the Professional components.  These files are marked with a PC or PS in the 

filename.  For example the file TPC.ZIP contains the patch for a 

SQL Anywhere Professional Client installed on an NT Workstation.



The Dynamo separate patch file for SQL Server Professional for Windows NT is named 

dynNN.zip



where LL is the patch level:

ú       11, 12, 03, etc... 





The SQL Anywhere filename format for the patches is:  PPWWNNLL.ZIP, where: 



PP is the installation platform:

ú       W3 for Windows 3.x (16-bit)

ú       NT for Windows NT (32-bit)

ú       95 for Windows 95

ú       DS for DOS

ú       O2 for OS/2

ú       NW for Netware



WW is the SQL product type:

ú       SA for standalone 

ú       SR for standalone with SQL Remote

ú       CL for client

ú       SE for server

ú       RT for runtime

ú       PC for Deluxe client

ú       PS for professional server
    
ú       LT for replication agent (LTM)    



NN is the version number:

ú       50 for Version 5.0      

ú       55 for Version 5.5      



LL is the patch level:

ú       01, 02, 03, etc... 



Step 2.  Combining .bin files into .zip files

-----------------------------
To minimize potential data losses during download crashes, the patch .zip file has been broken down into multiple .bin files. To combine these .bin files into one consolidated .zip file, please do the following.
· Find the patch that you want and download each .bin file - take note of the folder in which you save the files
· (Please note: when downloading .bin files, Netscape Communicator changes the extension from .bin to .exe by default. To remedy this, change the .exe extension to .bin in the "Save as" dialog box that appears when you are downloading.)
· Click on the batch file (file_name.bat) listed above the .bin files you have downloaded. This will take you to a text page
· You will find a "copy" command; copy it to your clipboard or save the batch file to the same folder as you copied your .bin files
· Open your DOS prompt and go to the folder in which you have saved the .bin files
· Paste the "copy" command that you copied from the batch file and press Enter; or, run the batch file that you created. This will create a single .zip file that matches the naming conventions listed in step 1.




Step 3.  Applying the patches

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

Create a temporary directory, and unzip the patch file into this directory.

For DOS installations set the temporary directory as your current directory 

and run setup.exe in that directory.  For Windows installations, double 

click on setup.exe from the explorer in the temporary directory.



Setup will then prompt you for the directory where the SQL Anywhere software

is installed. 

 

Step 3.  Description of the Patch 

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

The patch ZIP file contains a file called README.1ST.  This is a text file 

documenting bug fixes and changes that were made to this release of the 

software.