Chapter 7, Site Map Data Source error

Jaymond Flurrie · May 25th, 2015, 06:44 PM

I _think_ I have typed the code exactly like the book says. I get this when I run the code on page 250:

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Unable to connect to any of the specified MySQL hosts.

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

Source File: C:\Windows\Microsoft.NET\Framework\v4.0.30319\Conf ig\machine.config Line: 285

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34248

My Frontend.master looks like this:

Code:

<%@ Master Language="VB" CodeFile="Frontend.master.vb" Inherits="MasterPages_Frontend" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <asp:ContentPlaceHolder ID="head" runat="server">
    </asp:ContentPlaceHolder>
    <script src="/Scripts/modernizr-2.8.3.js"></script>
</head>
<body>
    <form id="form1" runat="server">
        <div id="PageWrapper">
            <header><a href="/"></a></header>
            <nav>
                <asp:Menu ID="Menu1" runat="server" CssClass="MainMenu" DataSourceID="SiteMapDataSource1" Orientation="Horizontal" StaticEnableDefaultPopOutImage="False"></asp:Menu>
                <asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" ShowStartingNode="False" />
            </nav>
            <section id="MainContent">
                <asp:ContentPlaceHolder ID="cpMainContent" runat="server">
                </asp:ContentPlaceHolder>
            </section>
            <aside id="Sidebar">
                Select a theme <br />
                <asp:DropDownList ID="ThemeList" runat="server" AutoPostBack="True">
                    <asp:ListItem>DarkGrey</asp:ListItem>
                    <asp:ListItem>Monochrome</asp:ListItem>
                </asp:DropDownList>
            </aside>
            <footer>Footer Goes Here</footer>
        </div>
    </form>
</body>
</html>

And the moment I remove this:

Code:

               <asp:Menu ID="Menu1" runat="server" CssClass="MainMenu" DataSourceID="SiteMapDataSource1" Orientation="Horizontal" StaticEnableDefaultPopOutImage="False"></asp:Menu>
                <asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" ShowStartingNode="False" />

it begins to work.

Any idea what could be wrong? What does MySQL have to do here? I do have MySQL installed, but I _thought_ it would be totally separate from Visual Studio.

Jaymond Flurrie · May 25th, 2015, 06:56 PM

Solved it:

http://stackoverflow.com/questions/2...-connector-net

In other words, check that if you have MySQL connector installed, that you _don't_ have Web Providers installed.

Tolugeorge · February 20th, 2016, 06:16 PM

If you follow pg 250 in the book to the letter and your site dint work.Manually Comment out the <sitemap> section (it's almost on the bottom of the file) in your machine.config file located in your .NET framework. Here is my part to the file:

C:\Windows\Microsoft.NET\Framework\v4.0.30319\Conf ig\machine.config

Save it as the administrator and violÃ¡. It works.

Solutions using sitemaps are intact solutions where I need to use the MySQL connector work as expected as well.