Visual Studio 2019 MySql Data Sources Failed to open connection Error

Question

Visual Studio 2019 MySql Data Sources Failed to open connection Error

Steve Hall 21

I'm having trouble setting up VS 2019 and MySQL together. I know you can't use VS 2022 + MySQL together, therefore looked to setup VS2019 with it so I could use the DataSources Window to drag and drop fields directly onto designer views. So started from a fresh installation of MySQL and Visual Studio 2019 on my dev machine - like both literally vanilla tonight. I used the Development installation for MySQL:

So I can connect to a test database just fine with Server Explorer. I can also Add Connection fine (that is it sees the remote database), but when I come to click next on Choose your data connection, I get this error:

I often come across this problem every time I try to set up MySql and VS together. On this occasion, I'm working with the latest MySQL version and thus have gone for the latest MySql binaries. As I say, I've reviewed all of the historic StackOverflow posts, but cant apply them to this. Could you please advise on what the issue is, as the error message isn't particularly helpful.

thanks

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-14T23:32:01.573+00:00

Hi, @Steve Hall Thanks for posting your question in the Microsoft Q&A forum.
Can you please confirm if you are using the .Net application or .Net Core? so I can reproduce the issue.

Regards
Geetha
Steve Hall 21 Reputation points

2022-09-15T18:45:40.74+00:00

Hi - thanks for the response, but I don't understand your question. I'm using Visual Studio. The problems happens if I'm am designing for both Framework or Core applications. I'm failing to see the relevance.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-15T21:26:08.207+00:00

@Steve Hall Can you check if you installed the MySQL driver for VS. Based on the error message the driver seems to be missing or try with installing and reinstalling the driver first and see if that resolves the issue.

https://dev.mysql.com/downloads/windows/visualstudio/

Regards
Geetha
Steve Hall 21 Reputation points

2022-09-15T21:33:02.297+00:00

So Geetha - the image in my first post shows all the drivers I have installed. You are unspecific about which driver. Is the one you mean in the list of ones I have installed? I have naturally tried uninstalling and reinstalling the rivers individually and also the full MySQL community installer: mysql-installer-community-8.0.30.0.msi
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-15T22:14:26.877+00:00

@Steve Hall Thanks for confirming currently i am trying in my environment and provide you with more details.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-15T22:19:35.987+00:00

@Steve Hall On Visual studio which project you are using ASP.NET core or ASP.NET and what is the version?
Here is the document you may also refer to if you have not checked it before.

Stackoverflow has a solution and details here

Regards
Geetha
Steve Hall 21 Reputation points

2022-09-18T10:37:13.56+00:00

Hi - yes - I have read that Page. I think as I have mentioned in my original post, I have vanilla VS2019 and MySQL installs via the community installer for both. Therefore should all work OK, but doesn't. It should comply with the first row of that table in the link you provided.

I'm not developing for ASP.net. I'm developing for desktop. I've tried it for WPF + Winforms both Framework + .net Core. I get the same error in all instances. Again, as I said in my original post, I have exhausted all of the Stack overflow posts, so directing me back to there isn't very helpful, I'm afraid.

I'm wondering whether you know someone who specialises in this a bit more, Geetha as we appear to be going round in circles a bit?

Alternatively, you could easily recreate the error by downloading and installing VBS2019 community + then the mySql community installer (with all the default settings) from here: mysql

Create a new database using Workbench or a tool like HeidiSQL. You'll see you can connect to it in VS using Server Explorer, but if you create a new WPF Framework project and try to create a new DataSource for MainWindow.xaml, you'll meet the error I'm getting.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-20T15:04:47.967+00:00

@Steve Hall Thanks for the additional information and apologies for the inconvenience caused, for me, the issue seems to be some missing drives so I have shared the document and StackOverflow solutions however you mentioned that you have already gone through the document then in that case I would recommend raising a support case for deeper investigation on what is missing.

Regards
Geetha
Steve Hall 21 Reputation points

2022-09-20T19:42:00.62+00:00

Hi - when you say "raise a support case" with whom and how, please? I thought I was doing this here, to be honest.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-21T19:33:51.717+00:00

@Steve Hall Did you get a chance to check my previous response?

Regards
Geetha
Steve Hall 21 Reputation points

2022-09-21T20:15:56.573+00:00

Hi - yes - I sent an email to that address and got no response.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-21T20:21:42.787+00:00

@Steve Hall I don't see any email did you mention the Subject: Attn Geetha?

Regards
Geetha

Your answer

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-14T23:32:01.573+00:00

Hi, @Steve Hall Thanks for posting your question in the Microsoft Q&A forum.
Can you please confirm if you are using the .Net application or .Net Core? so I can reproduce the issue.

Regards
Geetha
Steve Hall 21 Reputation points

2022-09-15T18:45:40.74+00:00

Hi - thanks for the response, but I don't understand your question. I'm using Visual Studio. The problems happens if I'm am designing for both Framework or Core applications. I'm failing to see the relevance.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-15T21:26:08.207+00:00

@Steve Hall Can you check if you installed the MySQL driver for VS. Based on the error message the driver seems to be missing or try with installing and reinstalling the driver first and see if that resolves the issue.

https://dev.mysql.com/downloads/windows/visualstudio/

Regards
Geetha
Steve Hall 21 Reputation points

2022-09-15T21:33:02.297+00:00

So Geetha - the image in my first post shows all the drivers I have installed. You are unspecific about which driver. Is the one you mean in the list of ones I have installed? I have naturally tried uninstalling and reinstalling the rivers individually and also the full MySQL community installer: mysql-installer-community-8.0.30.0.msi
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-15T22:14:26.877+00:00

@Steve Hall Thanks for confirming currently i am trying in my environment and provide you with more details.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-15T22:19:35.987+00:00

@Steve Hall On Visual studio which project you are using ASP.NET core or ASP.NET and what is the version?
Here is the document you may also refer to if you have not checked it before.

Stackoverflow has a solution and details here

Regards
Geetha
Steve Hall 21 Reputation points

2022-09-18T10:37:13.56+00:00

Hi - yes - I have read that Page. I think as I have mentioned in my original post, I have vanilla VS2019 and MySQL installs via the community installer for both. Therefore should all work OK, but doesn't. It should comply with the first row of that table in the link you provided.

I'm not developing for ASP.net. I'm developing for desktop. I've tried it for WPF + Winforms both Framework + .net Core. I get the same error in all instances. Again, as I said in my original post, I have exhausted all of the Stack overflow posts, so directing me back to there isn't very helpful, I'm afraid.

I'm wondering whether you know someone who specialises in this a bit more, Geetha as we appear to be going round in circles a bit?

Alternatively, you could easily recreate the error by downloading and installing VBS2019 community + then the mySql community installer (with all the default settings) from here: mysql

Create a new database using Workbench or a tool like HeidiSQL. You'll see you can connect to it in VS using Server Explorer, but if you create a new WPF Framework project and try to create a new DataSource for MainWindow.xaml, you'll meet the error I'm getting.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-20T15:04:47.967+00:00

@Steve Hall Thanks for the additional information and apologies for the inconvenience caused, for me, the issue seems to be some missing drives so I have shared the document and StackOverflow solutions however you mentioned that you have already gone through the document then in that case I would recommend raising a support case for deeper investigation on what is missing.

Regards
Geetha
Steve Hall 21 Reputation points

2022-09-20T19:42:00.62+00:00

Hi - when you say "raise a support case" with whom and how, please? I thought I was doing this here, to be honest.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-21T19:33:51.717+00:00

@Steve Hall Did you get a chance to check my previous response?

Regards
Geetha
Steve Hall 21 Reputation points

2022-09-21T20:15:56.573+00:00

Hi - yes - I sent an email to that address and got no response.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-09-21T20:21:42.787+00:00

@Steve Hall I don't see any email did you mention the Subject: Attn Geetha?

Regards
Geetha

Share via

Visual Studio 2019 MySql Data Sources Failed to open connection Error

Your answer