Hello friends

I am trying to connect to my MySql database on a dedicated server (from my home computer), but i keep running into different kind of errors. I keep debugging and try to solve the problems, but the last error is kinda driving me crazy, so I hope you can help me with my problem.

1. I have installed MySQL Connector .Net 5.2.1
   
2. I have installed MySQL Connector ODBC
3. I have created a new Project in VWD 2008 Express and included the MySql.Data.dll into my Bin folder
4. And I use the following code to connect to my MySql database:

Web.config:

   <connectionStrings>
    <add name="myConStr" connectionString="server=serverIP; database=dbName; user id=uName; password=pName;"/>
  </connectionStrings>

MasterPage.master.cs

using MySql.Data.MySqlClient;

....

try
        {
            using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["myConStr"].ConnectionString.ToString()))
            {
                con.Open();
                using(MySqlCommand cmd = new MySqlCommand("SELECT [field1] FROM [table] WHERE [field2] <= 10", con))
                using(MySqlDataReader dr = cmd.ExecuteReader())
                {
                    ddlUsers.DataSource = dr;
                    ddlUsers.DataBind();
                    dr.Close();
                }
                con.Close();
            }

        }
        catch(Exception ex)
        {
            errorMsgTop.Text = ex.Message.ToString();
           
        }

dllUsers is an <asp:DropDownList>.

But I keep getting this error:

error msg: Unable to connect to any of the specified MySQL hosts.
error source: MySql.Data

It's complaining about con.open(). I've tryed to connect with these database login values with my other (classic ASP) projekt and it works fine, but I can't make it work with ASP.NET. Can you please help me with this problem?

i have the same error.

 However I am not using the .net connector

i tried odbc and switched all the code to use the MySqlConnection but still same d@#$ thing.

I can connect fine through visual studio, through MySql Administrator and MySqlQuery browser.

For now I am connecting to another machine on my home network, but tried to two other remote mysql databases first.

I have tried endless combinations of connection strings!   Almost all of them work using visual studio or query browser.

This is very important to me.  thanks 

Here is my suggestion. Set up the server you want to work with on the Data Connections tab of  Visual Studio. With the 5.2.1  install of the .NET MySQL connector, it also installs some nifty features into VS like being able to view\edit\query,etc. to the Mysql database  from the Data connections window.   My point here is to check to see if the data connection, which is the formal way that mySQL developers suggest you create a tie in to your database, works.  You could have a firewall, norton,  etc. issue or it could be specific to Visual studio. Are you able to connect via MySQL Query browser?   Check the permissions and if push comes to shove, load up a  http sniffer to see if the requested connection is actually going to the remote server and coming back with a response.

daxmax:

Data Connections tab

That post was helpful and I did connect. 

Now I am back at this again but this time I cannot get the mysql.web.dll to register. 

MySql.Data.MySqlClient does not contain any public member

the mysql.web.dll will not register.   The mysql.data.client cannot find theNamespace.

i have added them to the projects, put the dll in the web bin folder, built the solutions and the built the website. 

I also have another project open and working with a registered mysql. 

I do not have it in the full project source code.  The full project shows me dependancies but will not let me add one.  

I should have documented this better the first time.

-- i will this time.

thanks