I have a ASP.NET page (mysql.aspx) which I want to connect to a MySQL database and run a SELECT query.
Then, from the result of the query, I want to create variables which can be used later in the script.
I have tried different code to connect to MySQL, but the page doesn´t show (HTTP 500 error).
What is the right way to connect and how do I create the variables?