Bug #82421 Can't create a Data Source in VS2015 Community

Submitted: 3 Aug 2016 10:55 Modified: 14 Nov 2016 17:36
Reporter: Guilherme Groke ggroke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Visual Studio Integration Severity:S3 (Non-critical)
Version:1.2.6 OS:Windows
Assigned to: CPU Architecture:Any
Tags: Data Source, VS 2015

[3 Aug 2016 10:55] Guilherme Groke ggroke
Description:
It's not possible create a MySQL data source in VS2015. It's possible to make a connection, access it by code.

But when trying to create a data source, when it comes to select the DB objects, it produces the error "Some updating commands could not be generated automatically. The database returned the following error: you have a usable connection already". 

Using:
Windows 8.1 
Visual Studio 2015 Community 
MySQL for Visual Studio 1.2.6
Connector/Net 6.9.9 

How to repeat:
Install VS2015 Community

Install MySQL for Visual Studio

Install MySQL Connector/Net

Create a new project

Select "Add a new data source"

Select "database", then "dataset"

Select a connection or create a new one (doesn't matter)

Select the tables from the database

Hit "Finish"

Suggested fix:
Fix this issue that says that the connection is already in use.
[3 Aug 2016 12:49] Chiranjeevi Battula
Hello Guilherme,

Thank you for the bug report.
Could you please provide repeatable test case (exact steps/sample project, MySQL version, create table statements/database etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[3 Aug 2016 13:11] Chiranjeevi Battula
Hello Guilherme,

Thank you for the bug report.
Verified this behavior on Visual Studio 2013 (C#.Net), Connector/NET 6.9.9 and MySQL for Visual Studio 1.2.6 version.

Thanks,
Chiranjeevi.
[3 Aug 2016 13:11] Chiranjeevi Battula
Screenshot

Attachment: 82421.JPG (image/jpeg, text), 198.10 KiB.

[14 Nov 2016 17:36] Javier TreviƱo
Fixed in version 2.0.4.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.