Manual uninstall of SA10
Dave Foulkes
revert to build 3689 in order to investigate a problem at a user site. When
I go to Control Panel and click on SQL Anywhere 10 Windows tells me "It may
have already been uninstalled". It has not. Windows also offers to remove
the entry from the Programs and Features list, but whether I select Yes or
No it does not.
Is it possible to "manually" uninstall SA10, and if so how?
TIA for any assistance.
Dave.
Josh Savill [Sybase]
To uninstall SQL Anywhere 10 manually
1. Ensure that all components are shut down, including database servers, and the Interactive SQL and
Sybase Central fast launchers. You can check whether the fast launcher processes are running by
opening the Task Manager, and looking for the processes dbisqlg.exe and scjview.exe. If these
processes are running, stop them before proceeding with the uninstall.
2. Delete the SQL Anywhere 10 installation files. This can be done by deleting the following folders
and the ones defined in the %SQLANY10% and %SQLANYSAMP10% environment variables:
a. The %SQLANY10% environment variable specifies the location of the SQL Anywhere 10 install. By
default, this environment variable is set to C:\Program Files\ SQL Anywhere 10. Remove all files
under the %SQLANY10% directory.
b. The %SQLANYSAMP10% environment variable specifies the location of the SQL Anywhere 10 samples. By
default, this environment variable is set to C:\Documents and Settings\All Users\Documents\SQL
Anywhere 10\Samples. Remove all files under the %SQLANYSAMP10% directory.
3. Remove the folder C:\Documents and Settings\All Users\Sybase Central 5.0.0.
4. Remove the folder C:\Documents and Settings\<Admin_User_For_Install>\sybase.
5. Remove all files in the Start menu by removing C:\Documents and Settings\All Users\Start
Menu\Programs\SQL Anywhere 10.
6. Remove the registry settings. If SQL Anywhere 10 is the only installed version of SQL Anywhere,
follow Step 6a, otherwise, use Step 6b.
a. Remove the following registry entries:
HKEY_CURRENT_USER\Software\Sybase
HKEY_LOCAL_MACHINE\SOFTWARE\Sybase
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\SharedDLLs\%SQLANY10%\*.* (C:\Program
Files\SQL Anywhere 10\*.*)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\dbmaen10.chm
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\dbeng10.exe
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{220C7FD5-D9EB-445A-BC17-337B93231774}
(SQL Anywhere installation) ++
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{3884B191-7826-4A78-8BAF-A41ECE27D883}
(SQL Anywhere Documentation) ++
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\HTML Help\ dbmaen10.chm
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\HTML Help\ scvwen500.chm
b. Remove the following registry entries:
HKEY_CURRENT_USER\Software\Sybase\SQL Anywhere
HKEY_LOCAL_MACHINE\SOFTWARE\Sybase\SQL Anywhere
HKEY_LOCAL_MACHINE\SOFTWARE\Sybase\Sybase Central\5.0.0
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\SharedDLLs\%SQLANY10%\*.* (C:\Program
Files\SQL Anywhere 10\*.*)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\dbmaen10.chm
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\dbeng10.exe
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{220C7FD5-D9EB-445A-BC17-337B93231774}
(SQL Anywhere installation) ++
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{3884B191-7826-4A78-8BAF-A41ECE27D883}
(SQL Anywhere Documentation) ++
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\HTML Help\ dbmaen10.chm
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\HTML Help\ scvwen500.chm
7. Remove the following environment variables set by the SQL Anywhere 10 install:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment\SQLANY10
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment\SQLANYSAMP10
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment\SQLANYSH10
8. Remove the following services configured for SQL Anywhere 10:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQL_ANYWHERE_10
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLANY*
Note: There may be multiple entries if there are multiple services defined. Remove all entries that
start with SQLANY*.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\SQLANY 10.0
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\SQLANY 10.0 Admin
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\SQLANY*
Note: There may be multiple entries if there are multiple services defined. Remove all entries that
start with SQLANY*.
9. Change the PATH environment variable to remove any paths to SQL Anywhere 10. The following
examples are for the default installation directory:
C:\Program Files\SQL Anywhere 10\win32
C:\Program Files\SQL Anywhere 10\Sybase Central 5.0.0\win32
10. Remove the Adaptive Server Anywhere string value from the following registry entry:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SNMP\Parameters\ExtensionAgents\SA
11. Remove the registry settings if Windows Mobile components are installed:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{D78F775A-6CFD-4A7E-8333-80AEE2DFA5CF}
(Windows Mobile installation) ++
12. Remove the following ODBC registry settings:
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\QAnywhere 10 Demo
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\SQL Anywhere 10 CustDB
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\SQL Anywhere 10 Demo
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources\QAnywhere 10 Demo
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Source\SQL Anywhere 10 CustDB
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Source\SQL Anywhere 10
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\iAnywhere Solutions 10 - Oracle
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Anywhere 10
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\UltraLite 10
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers\iAnywhere Solutions 10 - Oracle
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers\SQL Anywhere 10
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers\UltraLite 10
13. Remove ODBC registry entries for defined user data sources.
a. Remove any user data sources by removing the registry settings based on the data source name:
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\user_datasource_name
b. Remove the string value corresponding to the data source name:
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources\user_datasource_name
14. Remove the registry entries for ODBC system data sources.
a. Remove any system data sources by removing the registry settings based on the data source name:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\system_datasource_name.
b. Remove the string value corresponding to the data source name:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources\system_datasource_name.
15. Reboot the computer. This ensures that all environment changes have occurred, and cleans up any
necessary information related to the registry settings the have been removed.
++ This value is a GUID that identifies the SQL Anywhere 10 installation in the
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall directory. To determine which
GUID is for which SQL Anywhere installation, click the GUID, for example
{220C7FD5-D9EB-445A-BC17-337B93231774}. The DisplayName will show SQL Anywhere 10, Software for the
installation, SQL Anywhere, Documentation for the help files installation, and SQL Anywhere 10,
Windows CE for the Windows Mobile installation.
--
Joshua Savill
Sybase Inc. - Product Manager
Dave Foulkes
manual process than I'd envisaged, is there a "semi-automatic/semi-manual"
mechanism? Could there be some remnant of the original InstallShield process
I could invoke to do all this for me?
Regards,
Dave.
"Josh Savill [Sybase]" <no_spam_jsa...@sybase.com> wrote in message
news:4a1d503b$1@forums-1-dub...