Hi,
I am using a SqlDataSource control in a Default.aspx form in Visual Studio 2015. Trying to connect to MySql database. When I go through the wizard, everything works fine. All the tables were showing in the dropdown. But, when I tried to run the "test query", it generates the following error message.
"Could Not Create Connection. Object reference not set to an instance of an object".
If I am using the wizard in the SqlDataSource Control, I shouldn't have to worry about the connectionString setting in the web config as it automatically generated.
I also did check the web config setting, and the these lines of code are not even generated yet, as the wizard process was not completed. Because the error message interrupted in the middle of the wizard process. Please go to the following link for the slides (screenshots).
Any help will be greatly appreciated.
Thank you in advance....