.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

MySql connector/net problem

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :ASP.Net

I have a asp.net 4.0 site that can't connect to my hosting company's Mysql server

im using Mysql connector/net 6.3.4 also installed on host server.
i can run the site from my dev server or from my web Hosts server. as long as the connection string host name points to my dev mysql server ....all is good work great.
i have also tried using another company's hosted mysql server... everything works good.

all three databases were created from same dump file...

all three Mysql servers are v5

It would seem to me that my web site code is good.

whenever i change the server host name in the web.config file back to my hosting company's mqsql server i get this error.

This is the 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: Unable to initialize provider.  Missing or incorrect schema.

Source Error:

Line 50:         <add applicationName="/" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" />
Line 51:      &nbs

View Complete Post

More Related Resource Links

MySql.Data assembly problem



I added refernece MySql.Data to my project. My web.config looks like that:

<?xml version="1.0"?>
                <add assembly="MySql.Data, Version=, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>

But when in ServerExplorer I try "Add Connection..." I can't find "MySql Database" in the "Choose Data Source" dialog box?

What the problem can be?

Connection Problem with mysql and asp.net

i'm using this string to connect with mysql and asp.net but still agot the connection problem. the connection is not going to open............. i got the following error....... ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified please help me come from this problem "DRIVER={MySQL ODBC 3.51 Driver};DSN=sql4;SERVER=;DATABASE=myppw; UID=kraft; PASSWORD=myka; OPTION=3"

mysql data source provider - mysql connector/net

Dear All, I having problem installing mysql connector/net 6.2.3 on my vsd 2010 because the installed went smoothly but when Im trying to use the mysql on data source provider, I cant see it on the list and when try to install/change the connector the visual studio integreation has an x mark meaning to say it was not installed on my vsd2010.  Thanks.

Mysql connector and medium trust shared hosting

Hi at all. I've a big problem with GoDaddy Shared Hosting. I've written an ASP.NET application with MySql Database, but my application can't run, with the "Security Exception" error. The problem is that mysql connector must be recompiled with some .... different option. But i can't recompile.. i got always error. So i'm asking you if someone have a link for a mysql connector version able to run in medium trust environment.Very Thanks in advance.Bye

How to detect mysql connector version programatically?

Hi experts,Can I programatically find the version of mysql .net connector on the host machine from asp.net and update my web.config accordingly?Thanks in advance.

Problem Linking SQL 2008 with MySQL

Hi, Iam trying to add a Linked Server in sql2008 with a MySQL database. My OS is Windows SERVER 2008 64bit. My Odbc connection works just fine using mysql odbc connector 5.1 The Problem is that i cannot  establish the new linked server connection . I receive the following message : Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "B2B1". (.Net SqlClient Data Provider) Any Ideas? Thanks in advance  

import from mysql problem



I'm using SQL Management Studio 2008 to import a mysql dump. The dump was created with phpmyadmin with mssql compatibility turned on.This is what the dump looks like:

INSERT INTO frequencies (tx, rx, `mode`, description, `type`, location, `user`, modified, added) VALUES(163.11250, '', 'Nfm', test trunked radio system control. Watertower Cobh', 'Garda', 'Cork', 'Mike', '2005-02-03 23:00:00', '2005-03-15 10:38:30');

When I execute that sql I get an error

Msg 102, Level 15, State 1, Line 21

Incorrect syntax near '`'.


It looks like the syntax is wrong.Can anyone point me in the right direction. Thanks.

Problem in fetching data from Mysql



    I want to fetch data from mysql database to asp.net dropdown control. How can I do this.

I can fetch data from ms sql server to asp.net page. Please help me to fetch data from mysql database.


problem to connect mysql remote db


hi friends,

i am getting problem to connect to my remote sqlserver database..

i have connection string as follows


add name="ConnStr" connectionString="DRIVER={MySQL ODBC 3.51 Driver};SERVER=;PORT=3306;DATABASE=mydb name;UID=username;PASSWORD=mypasswd;OPTION=3;" />


i am giving all information correctly..

Mysql - Data instert/update problem


Hi all,

I developed a web site more then a year ago with .net2.0/c#/mssql 2005. it works fine but i was asked to replace mssql with mysql.

I wrote a class to complete data access works (unfortunately, I didnt use nhibernate or other data access tools :((

I edited the class to use System.Data.Odbc objects rather than System.Data.SqlClient.

It works fine in selecting data but not manipulating data. when i try to insert new data it adds null data for all fields in the table.

in debug mode, i noticed that it might be caused by OdbcParameter but not sure.

any idea??

thanks in advance

Login problem with MySQL forms authentication


I can login in locally using the development server, but after uploading the files- including MySql.Data.dll and MySql.Web.dll - to my hosting server I can't. There is no errors, it just won't login. I can get records from my database, so I know it's not the connection.

Here is my Web.config

<?xml version="1.0"?>

    <clear />
    <add name="LocalMySqlServer" connectionString="server=db_server_name;database=tempdb;user id=user_name; password=my_password" providerName="MySql.Data.MySqlClient" />

    <customErrors mode="Off"/>

    <membership defaultProvider="MySQLMembershipProvider">
        <clear />
        <add connectionStringName="LocalMySqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Clear" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwo

collation and charset Problem In MySql



my db collation  and char_st  are: utf8_general_ci and UTF

i use this code to insert to mydb:

string InsertCommand = //"set character_set_client= 'utf8';"+
                "set  collation_connection='utf8_general_ci';"+
                //"set character_set_connection= 'utf8'; " +
                //"SET  NAMES  'utf8' COLLATE 'utf8_general_ci' ;" +
            "INSERT INTO deads (DieID, Title, FName,LName,FatherName,BirthDate,BirthPlace,pin,DieDate,DieInfoDate,BlockID,BurialType,RowID,GraveID)" +
                "VALUES (?p_DieID, ?p_Title, ?p_FName,?p_LName,?p_FatherName,?p_BirthDate,?p_BirthPlac

problem connecting to mysql database



I'm new to ASP.net and I'm trying to connect to a mysql database but I'm getting this error when I'm running my application.  Access denied for user 'test_mysql'@'localhost' (using password: YES). I used this tutorial to get this far ( http://www.15seconds.com/issue/050210.htm ) but I don't know how to fix this.


Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

Regrading Sharpoint 2010 problem and solutions

We can write your question and problem on this blogger.you get ans.use.

This sharpoint 2010 problem solving threads

Hi friend,

you can use this thread to solving problem and solutions.

Virtual Path Problem


 I get the following error on last line below (working on remote host): 'E:\web\sfcascom\ls_admin/uploads/images/001.JPG' is not a valid virtual path,

Note that the slashes go in different directions

I've tried a number of things but nothing seems to work. Thanks-


Imports System.Drawing
Imports System.Drawing.Drawing2D
Imports System.Drawing.Imaging
Imports System.Web.UI.WebControls

Imports System.Drawing.Imaging.ImageCodecInfo
Partial Class Protected_imageupload
    Inherits System.Web.UI.Page
    Private Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click
        ' Initialize variables
        Dim sSavePath As String
        Dim sThumbExtension As String
        Dim intThumbWidth As Integer
        Dim intThumbHeight As Integer
        Dim sFilename As String = ""
        ' Set constant values
        'sSavePath = "images/"
        sSavePath = Server.MapPath("~/") + "ls_admin/uploads/images/"

        sThumbExtension = "_thumb"
        intThumbWidth = 160
        intThumbHeight = 120

        ' If file field isn?t empty
        If FilUpload.PostedFile IsNot Nothing Then
            ' Check file size (mustn?t be 0)
            Dim myFile As Http
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend