I created a Sql Sitemap provider on my dev DNN instance in 05.01.04 for use in a TreeView control I use in a module I created. Everything works great on my dev instance.

Then on prod I added the custom sql sitemap to the web.config file, added the customsqlsitemap.vb file into the directory of the module I added, but DNN will not recognize the customsqlsitemap.
ERROR:
DotNetNuke.Services.Exceptions.PageLoadException: The SiteMapProvider 'CustomSqlSiteMapProvider' cannot be found. ---> System.Web.HttpException: The SiteMapProvider 'CustomSqlSiteMapProvider' cannot be found. at System.Web.UI.WebControls.SiteMapDataSource.get_Provider() at System.Web.UI.WebControls.SiteMapDataSource.GetHierarchicalView(String viewPath) at System.Web.UI.HierarchicalDataSourceControl.System.Web.UI.IHierarchicalDataSource.GetHierarchicalView(String viewPath) at System.Web.UI.WebControls.HierarchicalDataBoundControl.GetData(String viewPath) at System.Web.UI.WebControls.TreeView.DataBindNode(TreeNode node) at System.Web.UI.WebControls.TreeView.PerformDataBinding() at System.Web.UI.WebControls.HierarchicalDataBoundControl.PerformSelect() at System.Web.UI.WebControls.BaseDataBoundControl.DataBind() at System.Web.UI.WebControls.TreeView.DataBind() at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() at System.Web.UI.WebControls.BaseDataBoundControl.OnPreRender(EventArgs e) at System.Web.UI.WebControls.TreeView.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

What am I missing?????

<siteMap defaultProvider="CustomSqlSiteMapProvider" enabled="true">
            <providers>
                <clear/>              
                <add name="CustomSqlSiteMapProvider" type="CustomSqlSiteMapProvider" connectionStringName="MySQLConnection"/>
            </providers>
        </siteMap>

Thank you for your quick reply! I may be lost or confused or both. When I created the custom sql sitemap provider in dev, I did not create it within it's own solution/compile it into a dll. I simply created a class for the provider and placed it within the module folder (that's using the provider) within the app_code folder. Where am I going wrong here? Does this method not work within DNN? From looking at the MSDN article(http://msdn.microsoft.com/en-us/library/44w5aswa.aspx) I am not sure what I am missing.
Thanks!

Alright, I figured out my issue and of course it was user error :)
I added the custom sql sitemap provider into the wrong area of the web.config file. I put it in the <dotnetnuke><sitemap> section instead of under the <web><sitemap> section.  D'oh!