Last post Jan 25, 2017 05:13 AM by wmec
Jan 09, 2017 03:34 PM|nicholasvaughan|LINK
I don't know if anyone is able to help me. I am using Visual Studio 2015 with the MySQL Connector 220.127.116.11 having just upgraded from VS2012 & MySQL Connector 6.8.8. When adding a listview to a webforms page, I can add the control, I connect to the MySQL
database, I can use the query builder to connect to the database and can run the 'Execute Query' button and get results back.
However when I come out of the query builder and finish going through the wizard to configure the SQL Datasource I click Test Query I get the following error message:
Unable to retrieve schema. Ensure that the ConnectionString and SelectCommand properties are valid. Object reference not set to an instance of an object.
This also applies when trying to refresh the schema for the ListView control. However If I manually write out the <ItemTemplate> and <LayoutTemplate> and build and run the site, the listview returns all the rows as expected. This means that the connection
string and the select statement are correct.
Has anyone else experienced this since upgrading from VS2015 with MySQL Connector 18.104.22.168?
Any help would be greatly appreciated.
Jan 25, 2017 05:13 AM|wmec|LINK