MySQL Bugs: #71926: Cannot connect to MySQL database from Visual Studio

Bug #71926	Cannot connect to MySQL database from Visual Studio
Submitted:	4 Mar 2014 14:32	Modified:	1 Mar 2016 16:42
Reporter:	Aaron Knight	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Visual Studio Integration	Severity:	S3 (Non-critical)
Version:		OS:	Windows (7 64bit)
Assigned to:	Luis Penunuri	CPU Architecture:	Any
Tags:	VS2012

Description:
Hi,

I am having issues similar to id#70676,
try to connect from visual studio with the right credentials, drop down list tells me cannot find databases. I have tried upgrading to 1.1.2 from 1.0.2 and I get an error that says "PublicAssemblies is not a valid short file name"

update fails

I have uninstalled MySQL Community, and I cannot uninstall MySQL for Visual Studio from Control Panel, get the same error.

Thanks in advance
help is much appreciated

How to repeat:
run MySQL installer
Check for updates
checked upgrade MySQL for Visual Studio 1.0.2 to MySQL for Visual Studio 1.1.2
execute

Which version of VS2012 you have? and try version 1.1.3. Thanks.

Visual Studio version 11.0.61030.00 Update 4 and I was mistaken and it should be MySQl for Visual Studio version 1.1.3 that I am updating to. The problem is still persisting.

Hi Aaron,
Have you tried using the standalone installer of MySQL for Visual Studio?

This is an independent installer so you only have to download this product msi.

Here is the link for downloading:
http://dev.mysql.com/downloads/windows/visualstudio/

Please let us know if this worked for you.

Thanks in advance!

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Same problem.

I've run the latest installer from here:
http://dev.mysql.com/downloads/windows/visualstudio/

I have Visual Studio 2010 and 2015 installed. When installing MySQL, it succeeds installing everything except for the latest MySQL for Visual Studio. I found out this is because that the previous version, 1.0.2 won't uninstall, due to this error.

Let me know if you need more info. I believe the core problem is that version 1.0.2 fails to uninstall.

I found the problem and a workaround. Hopefully someone opens and fixes this.

The problem was found by running the uninstaller:
C:\ProgramData\MySQL\MySQL Installer for Windows\Product Cache>MsiExec.exe /I{0D406BCC-D62A-46FB-9AB7-A7BF10FB8B31} /lvx* log.txt

In the log file I found this entry:
MSI (c) (70:24) [01:13:34:913]: PROPERTY CHANGE: Adding VS11_PublicAssemblies property. Its value is 'I:\Common7\IDE\PublicAssemblies'.

Most other entries was for the C drive, but this one looked odd. Since I didn't have an I drive, I mounted a random disk as my I drive. After that, it worked! I uninstalled 1.0.2 successfully.

The MySQL installer should be able to survive a drive not existing, and not just crash.

Unfortunately the log was overwritten when my last run succeeded, so I can't paste it here. Hope at least I can help others.

This bug was fixed as part of the fix for bug #71226 (http://bugs.mysql.com/bug.php?id=71226, "Cannot uninstall MySql for Visual Studio 1.0.2"), released in MySQL for Visual Studio 1.2.5.

Also, a workaround has been published here:
http://insidemysql.com/mysql-for-visual-studio-uninstall-workaround

No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".