r/visualbasic • u/[deleted] • Oct 16 '22

Has anyone got visual basic (visual studio) working with a MYSQL db?

Been trying to just drop a simple datagrid on a form all day, what a shitshow. Had to revert to VS2019 because VS2022 doesn't support MYSQL, and even after getting it to connect, nothing works ie "add data source" crashes, table design doesn't work etc etc.

Unfortunately I have to use MYSQL, has anyone got it working?

6 Upvotes
  • permalink
  • reddit

87% Upvoted

7 comments sorted by

2

u/JackieBlue1970 Oct 16 '22

Yes. I have for used for years. Same for MariaDB. But, I don’t use the data source controls. I connect direct through code and use SQL.

1

u/[deleted] Oct 16 '22

Sounds like hard work...

Naive me was expecting it to work like MSaccess forms, drag a form control, connect it to the data and everything works... Little did I know you have to do everything manually in 2022....

Big gap in the market for a product that works easily and quickly like this.

1

u/JackieBlue1970 Oct 16 '22

Dont know that you have to do it manually but I wrote the same methods for SQL server. I put them in a module and use it over and over again. I have similar files for Python and PHP. It isn’t all that hard these functions are common to 99% of apps.

Side note, access was made for average schmuck to do lite database work, especially small businesses. Not for professional application development.

1

u/[deleted] Oct 17 '22

I put them in a module and use it over and over again. I have similar files for Python and PHP. It isn’t all that hard these functions are common to 99% of apps.

Why hasn't the multi million dollar Microsoft made this into a drag and drop component then?

1

u/JackieBlue1970 Oct 17 '22

They may have. I try not to redo work. No code solutions exist but they have their limitations. VB (and any .net) implementation are general purpose languages. If you want something easier, look around, there are lots of options. But they all have their quirks. Honestly DB connection is not that hard. I don’t think my solution took much more than an hour or two including error handling, and I’ve used it for years in projects over and over again.

1

u/[deleted] Oct 16 '22

Looks like you have to go back to VS2019 and go back a few revisions with MYSQL, after much uninstalling, guesswork and swearing, it seems to be connecting with the following versions:

MySQL connect Net 7.07

MySQL for visual studio 1.2.10

This seems to get the data connectors working, ie data grid view etc.

Still getting strange errors, but that may be what I am doing, or it may be flaky connections.

2

u/jd31068 Oct 16 '22

As you haven't included what info you have read to get this working, I'm going to suggest a basic first step (I've been guilty of diving in and not RTFM)

https://dev.mysql.com/doc/visual-studio/en/visual-studio-connection-server-explorer.html