I can't seem to find the patch to update 9.0.x to 9.0.2. I need to be able to support a handful of Win7 x64 boxes until we have a chance to upgrade.
Anyone know where I can find the patch?
asked 21 Jul '11, 11:49
You have a few options for getting on to x64 software, but as Bill mentioned, you must be on version 9.0.2.x - 9.0.0.x does not offer x64 software. You can still continue to run the x86 binaries on x64, however.
1) 9.0.0, 9.0.1, and 9.0.2 GA did not contain "x64" support when released. SQL anywhere was only available for "x86" and "IA64" (Itanium), even at version 22.214.171.1241. If you see "9.0.2 64-bit" on an install CD, this is likely referring to the Itanium version.
2) x64 support was released with the 126.96.36.19949 EBF (and up). Installing the 9.0.2 GA onto an x64 OS will only provide you with the 32-bit binaries. Updating the 9.0.2 EBF level past 3249 (with an 'x64' 9.0.2 EBF) should deploy an "%ASANY9%\x64" directory.
3) SQL Anywhere must have a maintenance patch applied to it in order for you to go from 9.0.x to 9.0.2.
There is no patch of 9.0.x for Windows x64. Version 9.0.2 was the first to support 64-bit Windows.
answered 21 Jul '11, 12:50
Install 9.0.2 x64 freshly on your box and just use the database file from you 9.0.0 Version.
upgrade your 9.0.0 to 9.0.2 x86 as it will run under Win7 x64 and as probably you will not gain any advantage being able to use more memory on the client system (x64).
If your client software is x64 you will have to use the x64 drivers to access the database so use solution 1. You can still host your database in the 32-bit version of the dbsrv or dbeng if you like, the x64 drivers can access a 32 bit db server.
answered 22 Jul '11, 03:05