Hallo All, can anyone of us help me in understanding if there is the possibility to install my SQL Anywhere v. 5.5.04 on a machine with Windows 7, and if yes, how to?
Thanks a lot for your kind answer. Warmest Regards Ciao Fabio
Version 5.x is "not supported", but it may work reasonably well on Windows 7. You will be operating in an environment that we have never tried and won't be able to help with.
When Windows Vista first came out, we had to make some changes to SQL Anywhere 9 and up. These changes may identify issues you will encounter. This page from the SA10 documentation may provide additional insights: Windows Vista support issues
In particular, you require administrator privileges more often under Windows Vista and Windows 7. In supported versions of SQL Anywhere, we added code to request permission to proceed with certain activities (called "elevated operations"). Without this code, the activity may simply fail.
There were also issues with shared memory. Using TCP/IP may work better.
If it is possible to move to 5.5.05 latest EBF, that would make a more stable platform to continue with, but as mentioned it is not easily available. You would have to open a support case.
have a look at SQL Anywhere Supported Platforms and Engineering Support Status.
9.0.2 is also officially supported on Windows 7 if you have the latest EBF 3924
So for 5.5.04 you might be lucky but I would suggest to upgrade, you will get lots of good stuff doing so.
answered 13 Jul '11, 09:03
I've got it working on Win7 64bit with some registry entries culled from various places including http://www.developer.com/db/article.php/3712461/Installing-a-Custom-ODBC-Driver-on-Windows-for-SQL-Anywhere.htm.
1) Install as normal as an administrative user.
2) For good measure, I marked the executable files in %installfolder%\sqlany50\win32 as running in compatibility mode for WinXP SP3 and 'Run as administrator'.
3) Added a new string-value 'Sybase SQL Anywhere 5.0' at 'HKLM\Software\Wow6432Node\ODBC\ODBCInst.INI\ODBC Drivers' with a value of 'Installed'.
4) Added a new 'Sybase SQL Anywhere 5.0' key to 'HKLM\Software\Wow6432Node\ODBC\ODBCInst.INI'.
5) Added a new string-value 'Driver' with a value of '%installfolder%\sqlany50\win32\wod50t.dll'.
6) Added a new string-value 'Setup' with a value of '%installfolder%\sqlany50\win32\wod50t.dll'.
7) Added a new 'Sybase SQL Anywhere 5.0 Translator' key to 'HKLM\Software\Wow6432Node\ODBC\ODBCInst.INI'.
8) Added a new string-value 'Setup' with a value of '%installfolder%\sqlany50\win32\ wtr50t.dll'.
9) Added a new string-value 'Translator' with a value of '%installfolder%\sqlany50\win32\wtr50t.dll'.
Hi, all. I thought this thread might have expired long ago. I 'filed' my answer here for future reference in case I lost my notes!
Re the ODBC drivers creating the registry entries, I can only go by what I found (or didn't find) in my own registry - they definitely weren't there so I popped them in and all seems well. Might be that the install routine was blocked from accessing the registry?
Regarding stability, it seems okay on my test box - none of our production staff are running 64bit as yet for me to give the all clear.
answered 12 Jun '13, 07:56