Is there a standard connection dialog for mysql?

33
March 15, 2019, at 8:30 PM

I have written an windows form app in C# that gets distributed to various data partners. The purpose of this app is to connect to one of their locally controlled databases, extract data according to SQL they provide and then to send it directly to our services using protected and encrypted methods.

One of the steps each partner needs to perform to pull and send us their data is to connect to their database. Most of my data partners us SQL Server. When these partners select the option to 'Connect to DB' my code executes:

var dialog = new DataConnectionDialog();

dialog.DataSources.Add(DataSource.SqlDataSource);

This presents them with the standard SQL Server connection. We do this because none of the data partners want us to store any part of their connection parameters so we have to ask them each time for all of the details.

I do have at least one data partner who is using MySQL. I had tried to use an ODBC connection datasource but have run into problems. One option to avoid these problems is to use the MySQL.Data library.

However I cannot find a way to bring up the standard MySQL connection dialog so the user can provide servername, port, username, password, etc.

Is there one and if so, how can I call it and obtain the connection parameters?

Thank you,

READ ALSO
Openproject installing to PostGre instead of MySQL

Openproject installing to PostGre instead of MySQL

Installing Openproject to a rented Ubuntu 1804 server

42
How to set mysql user variable at every new connection in Laravel 5.5?

How to set mysql user variable at every new connection in Laravel 5.5?

Background: We rely heavily on views in our app and one of the ways in which we are looking to optimize them is by parameterizationWe've got that aspect all figured out, but in order to make it work, I must be able to set a user parameter for the customer...

48
Mysql adding index for column type text does not improve performance while using select query

Mysql adding index for column type text does not improve performance while using select query

I am using InnoDBFrom this question, I found out that I have to specify the length if I want to add index to columns which type is TEXT

52