Solved

Configuration Error

Posted on 2010-08-27
5
1,174 Views
Last Modified: 2012-05-10
I have a form that is built using ASP.NET and it has a MySql backend.  It works perfectly on my local machine but when I upload it to Godaddy, I get the following error and they can' help me with it.


Server Error in '/' Application.
--------------------------------------------------------------------------------

Configuration Error
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: Could not load file or assembly 'MySql.Data, Version=6.2.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

Source Error:


Line 45:                         <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
Line 46:                         <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
Line 47:                         <add assembly="MySql.Data, Version=6.2.3.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
Line 48:                         <add assembly="MySql.Data.Entity, Version=6.2.3.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
Line 49:                         <add assembly="MySql.Web, Version=6.2.3.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/></assemblies>
 

Source File: D:\Hosting\6576360\html\web.config    Line: 47

Assembly Load Trace: The following information can be helpful to determine why the assembly 'MySql.Data, Version=6.2.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' could not be loaded.


WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

 

.NET File

----------

<%@ Page Language="C#" MasterPageFile="~/MasterPage2.master" AutoEventWireup="true" CodeFile="contact.aspx.cs" Inherits="contact" Title="Lara Fabrics - Contact" %>



<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<div id="center_content">

        

        <div class="title"><img src="images/contact_title.gif" alt="" title="" /></div>

        

		<div class="product_box">



        

		        <div id="contact_form">

                        <label class="contact_form">Name:</label>

		      			<input type="text" name="name" class="contact_input" runat="server" id="name" />

		       			<div class="cleardiv"></div>

                        <label class="contact_form">Email:</label>

		      		 	<input type="text" name="email"  class="contact_input" runat="server" id="email"/>

		       			<div class="cleardiv"></div>

                        <label class="contact_form">Message:</label>

		      		 	<textarea name="message" cols="7" rows="10" class="contact_textarea" 

                            runat="server" id="message"></textarea>

		       			<div class="cleardiv"></div>

                        <%--<input type="image" src="images/submit.gif" id="image" class="contact_submit" runat="server" onclick="image_Click" />                        --%>

                        <asp:Button ID="Button1" runat="server" Text="Button" onclick="image_Click" />

      		            <asp:Label ID="lblError" runat="server" Text=""></asp:Label>

                    

            

      		   </div>







        </div>

              

        



        

        

        </div>

</asp:Content>





Code Behind

-----------

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using MySql.Data.MySqlClient;

using System.Data.SqlClient;



public partial class contact : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {



    }



    protected void image_Click(object sender, EventArgs e)

    {

        //MySqlConnection connection = new MySqlConnection("Network Address=localhost;" +

        //                                        "Initial Catalog='manyss';" +

        //                                        "Persist Security Info=no;" +

        //                                        "User Name='root';" +

        //                                        "Password='xxxx'");



        MySqlConnection connection = new MySqlConnection("Network Address=csofab49.db.6576360.hostedresource.com;" +

                                                "Initial Catalog='manyss';" +

                                                "Persist Security Info=no;" +

                                                "User Name='xcvxxxxxx';" +

                                                "Password='Mxxxxxxxx'");





        string cmdText = "INSERT INTO tblProducts(name ,email ,message)";

        cmdText += "VALUES(?name ,?email ,?message);";



        MySqlCommand cmd = new MySqlCommand(cmdText, connection);



        cmd.CommandType = CommandType.Text;



        cmd.Parameters.Add("?name", MySqlDbType.VarChar).Value = name.Value.ToString();



        cmd.Parameters.Add("?email", MySqlDbType.VarChar).Value = email.Value.ToString();



        cmd.Parameters.Add("?message", MySqlDbType.VarChar).Value = message.Value.ToString();



        connection.Open();

        try

        {



            int result = cmd.ExecuteNonQuery();



            lblError.Text = "Data Saved";

        }

        catch (Exception ex)

        {

            lblError.Text = ex.Message;

        }

    }

}







Web.config

----------

<?xml version="1.0"?>

<!-- 

    Note: As an alternative to hand editing this file you can use the 

    web admin tool to configure settings for your application. Use

    the Website->Asp.Net Configuration option in Visual Studio.

    A full list of settings and comments can be found in 

    machine.config.comments usually located in 

    \Windows\Microsoft.Net\Framework\v2.x\Config 

-->

<configuration>

	<configSections>

		<sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

			<sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

				<section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

				<sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

					<section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>

					<section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

					<section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

					<section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

				</sectionGroup>

			</sectionGroup>

		</sectionGroup>

	</configSections>

	<appSettings/>

	<system.web>

		<!-- 

            Set compilation debug="true" to insert debugging 

            symbols into the compiled page. Because this 

            affects performance, set this value to true only 

            during development.



            Visual Basic options:

            Set strict="true" to disallow all data type conversions 

            where data loss can occur. 

            Set explicit="true" to force declaration of all variables.

        -->

		<compilation debug="true" strict="false" explicit="true">

			<assemblies>

				<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

				<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

				<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

				<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

				<add assembly="MySql.Data, Version=6.2.3.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>

				<add assembly="MySql.Data.Entity, Version=6.2.3.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>

				<add assembly="MySql.Web, Version=6.2.3.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/></assemblies>

		</compilation>

		<pages>

			<namespaces>

				<clear/>

				<add namespace="System"/>

				<add namespace="System.Collections"/>

				<add namespace="System.Collections.Generic"/>

				<add namespace="System.Collections.Specialized"/>

				<add namespace="System.Configuration"/>

				<add namespace="System.Text"/>

				<add namespace="System.Text.RegularExpressions"/>

				<add namespace="System.Linq"/>

				<add namespace="System.Xml.Linq"/>

				<add namespace="System.Web"/>

				<add namespace="System.Web.Caching"/>

				<add namespace="System.Web.SessionState"/>

				<add namespace="System.Web.Security"/>

				<add namespace="System.Web.Profile"/>

				<add namespace="System.Web.UI"/>

				<add namespace="System.Web.UI.WebControls"/>

				<add namespace="System.Web.UI.WebControls.WebParts"/>

				<add namespace="System.Web.UI.HtmlControls"/>

			</namespaces>

			<controls>

				<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

				<add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

			</controls>

		</pages>

		<!--

            The <authentication> section enables configuration 

            of the security authentication mode used by 

            ASP.NET to identify an incoming user. 

       

        <authentication mode="Windows" />

       

            The <customErrors> section enables configuration

            

            

            

            

           

            of what to do if/when an unhandled error occurs 

            during the execution of a request. Specifically, 

            it enables developers to configure html error pages 

            to be displayed in place of a error stack trace.

                    <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">

            <error statusCode="403" redirect="NoAccess.htm" />

            <error statusCode="404" redirect="FileNotFound.htm" />

        </customErrors>

-->

		<customErrors mode="Off"/>

		<httpHandlers>

			<remove verb="*" path="*.asmx"/>

			<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

			<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

			<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>

		</httpHandlers>

		<httpModules>

			<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

		</httpModules>

	</system.web>

	<system.codedom>

		<compilers>

			<compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

				<providerOption name="CompilerVersion" value="v3.5"/>

				<providerOption name="WarnAsError" value="false"/>

			</compiler>

			<compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" warningLevel="4" type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

				<providerOption name="CompilerVersion" value="v3.5"/>

				<providerOption name="OptionInfer" value="true"/>

				<providerOption name="WarnAsError" value="false"/>

			</compiler>

		</compilers>

	</system.codedom>

	<!-- 

        The system.webServer section is required for running ASP.NET AJAX under Internet

        Information Services 7.0.  It is not necessary for previous version of IIS.

    -->

	<system.webServer>

		<validation validateIntegratedModeConfiguration="false"/>

		<modules>

			<remove name="ScriptModule"/>

			<add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

		</modules>

		<handlers>

			<remove name="WebServiceHandlerFactory-Integrated"/>

			<remove name="ScriptHandlerFactory"/>

			<remove name="ScriptHandlerFactoryAppServices"/>

			<remove name="ScriptResource"/>

			<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

			<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

			<add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

		</handlers>

	</system.webServer>

	<runtime>

		<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

			<dependentAssembly>

				<assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>

				<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>

			</dependentAssembly>

			<dependentAssembly>

				<assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>

				<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>

			</dependentAssembly>

		</assemblyBinding>

	</runtime>

</configuration>

Open in new window

0
Comment
Question by:Isaac
  • 2
  • 2
5 Comments
 
LVL 30

Expert Comment

by:Brad Howe
Comment Utility
Hi,
How are you configuring your DSN in the code to handle the new environment? From the error, your environment is lacking the MySQL ODBC drivers OR your could is not configured correctly to access the DB in the godaddy environment.
Install DSN - http://help.godaddy.com/article/3326
Connect ot DSN (ASP) - http://help.godaddy.com/article/260
Let us know,  Cheers,
Hades666
0
 
LVL 5

Author Comment

by:Isaac
Comment Utility
Thanks for the article.
I'm in the process of creating a DSN on Godaddy.  It's currently pending.
How do I use it in my code?
0
 
LVL 16

Expert Comment

by:Vikram Singh Saini
Comment Utility
Hi,

Refer the link:
http://forums.asp.net/p/1549089/3793427.aspx

Regards,
VSS
0
 
LVL 5

Author Comment

by:Isaac
Comment Utility
The link you provided refers to another link which talks about Infopath which is not too helpful to me.
0
 
LVL 30

Accepted Solution

by:
Brad Howe earned 500 total points
Comment Utility
Hi,
Sorry went to bed. Here you go.
http://www.c-sharpcorner.com/UploadFile/yougerthen/307292008122410PM/3.aspx
Essenetially, create the obecjt, connect to the DSN open the connection and do you DB queries.
-Hades666
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now