locked
MySQL connector - Unable to retrieve schema (VS2015 - MySQL Connector 6.9.9.0) RRS feed

  • Question

  • User1775706248 posted

    Hi,

    I don't know if anyone is able to help me.  I am using Visual Studio 2015 with the MySQL Connector 6.9.9.0 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 6.9.9.0?

    Any help would be greatly appreciated.

    Thanks,

    Nick

    Monday, January 9, 2017 3:34 PM