Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
432 views
in Technique[技术] by (71.8m points)

c# - MySQL Visual Studio 2015 You have a usable connection already

I'm fairly experienced with Visual Studio 2013 and I'm now upgrading to VS 2015 and running into and issue adding a new datasource to a Windows Forms Application. It is very easy to recreate my issue.

Here's my setup:

Visual Studio 2015 Enterprise 2015 Update 3
MySQL for Visual Studio 1.2.6
Connector/Net 6.9.9

Note: The above configuration is supported according to the support information matrix located at http://dev.mysql.com/doc/visual-studio/en/visual-studio-install.html and I've also tried just about every other permutation of supported software listed there.

Here's how to recreate the issue:

New C# Windows Forms Application
Add New Data Source
Database
Dataset
New Connection (connects just fine)
Save the connection
Choose your database objects
Select any table
Finish

Error: Some updating commands could not be generated automatically. The database returned the following error: You have a usable connection already.

Grateful for anyone who can even give a clue as to what I might be doing wrong.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
  1. Install mysql-for-visualstudio-2.0.4.msi (here).
  2. Install Connector/Net 6.9.9.msi (here).

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...