MySQL Bugs: #54314: Connector/ODBC 5.1 series requires uninstall prior to installing a new version

Bug #54314	Connector/ODBC 5.1 series requires uninstall prior to installing a new version
Submitted:	7 Jun 2010 22:33	Modified:	6 Oct 2010 16:03
Reporter:	Donna Harmon	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S4 (Feature request)
Version:	5.1	OS:	Windows (XP)
Assigned to:	Lawrenty Novitsky	CPU Architecture:	Any

Description:
When trying to install the latest Connector/ODBC 5.1.6 on Windows using the .msi, with an existing 5.1.x version already installed, you receive the following error:

"Another version of this product is already installed.  Installation of this version cannot continue.  To configure or remove the existing version of this product, use Add/Remove Programs on the Control Panel."

Also, when uninstalling 5.1.x and installing a different 5.1.x version, the version in the ODBC Data Source Administrator/Drivers tab does not get removed(when uninstalled) nor changed when a different 5.1.x version is installed.

How to repeat:
Install 5.1.5 using the .msi and then try installing 5.1.6

Suggested fix:
Provide upgrade option or allow multiple versions be installed and also update the version in the ODBC Data Source Administrator.

Thank you Donna. We are aware of this, let's see what can be done as replacing 5.1.6 might not prove that easy, especially with all the additional x64/x32 handling code.

(a bit tentative) patch

Attachment: bug54314.patch (text/x-patch), 9.75 KiB.

Probably it is not related to the bug itself, but these two things need fixing:

 1. svn+ssh://<your-uid>@bk-internal.mysql.com/connectors-svnroot/wix-installer
    is still in SVN repository. Would be good to move it into BZR

 2. wix\README.TXT contains misleading instructions about setting WIX_RESOURCE
    env variable. It says:

- WIX_RESOURCE
Resource directory from svn+ssh://<your-uid>@bk-internal.mysql.com/connectors-svnroot/wix-installer

    Not quite clear that it has to point to resources (not Resource)
    sub-directory inside wix-installer.

An entry has been added to the 5.1.8 changelog:

When attempting to install the latest Connector/ODBC 5.1.6 on Windows using the MSI, with an existing 5.1.x version already installed, the following error was generated:

Another version of this product is already installed.  Installation of this version
cannot continue.  To configure or remove the existing version of this product, use
Add/Remove Programs on the Control Panel.

Also, the version number displayed in the ODBC Data Source Administrator/Drivers tab did not get updated when removing or installing a new version of 5.1.x.