MySQL Bugs: #39019: Visual Studio path is hardcoded in .NET connector installer

Bug #39019	Visual Studio path is hardcoded in .NET connector installer
Submitted:	25 Aug 2008 20:57	Modified:	8 Sep 2008 14:40
Reporter:	Fredrik
Status:	Closed
Category:	Connector/Net	Severity:	S3 (Non-critical)
Version:	5.2.3	OS:	Microsoft Windows (XP)
Assigned to:		Target Version:
Tags:	installer, path, hardcoded, Visual Studio

Description:
When i try to install the .Net connector on my PC the Installer is interupted before the
end, and only says that it was ended prematurely, without any describing error.

I enabled verbose logging on for MSI installers, and found this:

CAQuietExec: "D:\Program Files\Microsoft Visual Studio 8\Common7\IDE\\devenv.com" /setup
CAQuietExec: Error 0x80070002: Command failed to execute.

I have installed Visual Studio on "E:\Visual Studio 8\" - NOT the default path. 0x80070002
means "file not found/missing", which is correct.

More info here:

http://forums.mysql.com/read.php?38,223330,223330#msg-223330

How to repeat:
Install Visual studio to a NON-DEFAULT path.
Install .Net connector v5.2.3 (or any other)

Suggested fix:
Do not use a hardcoded path to Visual Studio.

Fredrick

The installer does not have the path hardcoded.  What it does is retrieve the registry
value SOFTWARE\Microsoft\VisualStudio\8.0\Setup\VS\EnvironmentDirectory.  Can you check
that registry value on your system and tell me what it's value is?  Also, can you tell me
the value of SOFTWARE\Microsoft\VisualStudio\8.0\Setup\VS\EnvironmentPath on your system?

This is not a bug.  We do not have the path of VS hard coded.  We read it directly from
the registry so the users registry must be messed up.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\8.0\ has wrong path info's. So it's my
fault. I have know idea why this is even there, since i don't have Visual Studio 2005
installed (8.0 = 2005?)

But HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\ has correct path info's.
Shouldn't the MySQL installer read these values instead, since that is the latest version
installed on the system?

It reads both.  The installer attempts to register the product with VS 2005 and 2008.  So
it reads the 8.0 key for VS 05 and the 9.0 key for VS 08.

I am marking this as verified, not because we hard code paths but because our installer
was not handling gracefully the case where the path or target doesn't exist.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/52936

fixed in 5.3.0

An entry was added to the 5.3.0 changelog:

The Connector/NET installer program ended prematurely without reporting the specific
error.