Hi all, 

I have run into an issue and not able to resolve it. 

There was a requirement to connecting to a MySQL data source. For that I unknowingly added an entry in the "ODBC Data Source Administrator" -> User DSN & System DSN 

I was totally unaware that I am breaking my SP setup (Development). Now Central Admin site and all other sites have stopped working. 

I tried repairing by re-running the config wizard but no use. Error I get is "An unexpected error has occurred." OR "Unable to connect to any of the specified MySQL hosts." 

But when I try accessing other site, its showing an error from the "machine.config" file: >

Line 284:    <siteMap>
Line 285:      <providers>
Line 286:        <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=6.9.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />
Line 287:      </providers>
Line 288:    </siteMap>

Source File: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config 

For record, I have already removed those entries from that User DSN & System DSN. Still error persists. 

If some has ANY IDEA how to resolve it... please help! 

Can you give us a description of what is happening? Errors form the Application and System Event Log, and/or ULS logs?

Hi Nayan,

I faced the same problem as you encounter. I have Googling for 1 hours. This is the MySQL Connector bugs.  For some solution is to comment out the config in machine.config file.

the path of machine.config file as below

C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config 

<!--        <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, 

MySql.Web.v20, Version=6.9.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" 

connectionStringName="LocalMySqlServer" applicationName="/" /> -->

But this solution not work for me.

So the next solution is to change the installation file by go to control panel -> program -> select Mysql connector and select change. uncheck the web provider and next all the way. Then the issues resolve. Hope it help.

Regards,

RenneHong

Hi Renne,

Yes I had ultimately implemented the same workaround to overcome this.

After commenting many such tags which get added automatically after installing MySQL connector 6.9; our setup starts working again.

Wow thanks for this one :) but what is the consequences for unchecked web provider?

Yes it is working in my case. Thanks

• Proposed as answer by Pradip G 25 minutes ago

Yes it is working in my case. Thanks

• Proposed as answer by Pradip G 17 minutes ago