Can't connect to the MySQL database online. Please help!

Hi guys,

I'm new to ASP.NET (as you will be able to tell, i'm sure ; )

I can't connect to MySQL database on the live server. I've been trying for days and am going mad!

This is what i got form my host(will change security sensitive stuff):

Your MySQL database settings
Server Name:    mysql-913
Server IP Address:      243.131.32.34
Database Name:          zebradat
Database Username:      zebradatadmin
Database Password:      3vex491

Can someone tell me please what my connection string should look like based on the above.

Is below correct??

I need to name my database zebradat.mdf? Am i correct?

Your help will be much appreciated!

Re: Can't connect to the MySQL database online. Please help!

You probably don't want to be using System.Data.SqlClient. You should download and install a MySQL-specific .NET provider of which there are a few. Then you can get your connection string format here:

http://www.connectionstrings.com/?carrier=mysql

Though most hosting providers have some option to let you view the DB connection string.

Hope this helps...

Re: Can't connect to the MySQL database online. Please help!

You need to go to this page

http://dev.mysql.com/downloads/#connector-net

And download MySQL Connector/Net

Then Just like you would use System.Data.SqlClient,

you will have MySql.Data.MySqlClient once you add a reference to the files downloaded above.

Then you will have a set of parallel classes similar to System.Data.SqlClient

SqlCommand = MySql.Data.MySqlClient.MySqlCommand

SqlConnection = MySql.Data.MySqlClient.MySqlConnection

And so on...

As for the format of the connection string

It is like this

private static string _connectionString =

@"Persist Security Info=False;" +

@"database={0};" +

@"server={1};" +

@"user id={2};" +

@"Password={3};" +

@"Port={4};";

Where you fill in each value in its place using String.Format.

Hope this helps.

Re: Can't connect to the MySQL database online. Please help!

Thank you so much for your replys guys. Will try this out and let you know how I get on. Thnx again

Re: Can't connect to the MySQL database online. Please help!

I have downloaded the connector, but how do I utilise it /"add the reference" to it? I've installed and run locally.. any links to a step by step guide as the instructions on the dev.mysql.com are too advanced for me. I need very basic noob step-by-step instructions as I have no experience w MySQL databases.. Thank you very much in advance

Re: Can't connect to the MySQL database online. Please help!

Right click on references under your project. Choose the Browse tab. and then browse for the dll that you downloaded, the last time I downloaded it, its name was "MySql.Data.dll"

Re: Can't connect to the MySQL database online. Please help!

Thank you very much ralph! I have referenced MySql.Data.dll as per your instruction, but am wondering are any new strings suppose to appear in my web.config file (or in my assembly or...)as the result of this action?? Where can find those classes that you mention below?

You need to go to this page

http://dev.mysql.com/downloads/#connector-net

And download MySQL Connector/Net

Then Just like you would use System.Data.SqlClient,

you will have MySql.Data.MySqlClient once you add a reference to the files downloaded above.

Then you will have a set of parallel classes similar to System.Data.SqlClient

SqlCommand = MySql.Data.MySqlClient.MySqlCommand

SqlConnection = MySql.Data.MySqlClient.MySqlConnection

And so on...

As for the format of the connection string

It is like this

private static string _connectionString =

@"Persist Security Info=False;" +..................."

This is supppose to go into the web.config file i assume?

Can you please elaborate on this, give examples,(as I did hours of search/reading after your last reply but didn't get anywhere/am non the wiser : (

Many thanks for all your help ralph!

Re: Can't connect to the MySQL database online. Please help!

If you have added the reference then all you need to continue is

MySqlConnection connection = new MySqlConnection(your connection string here)

Your connection string would be

"database={0};server={1};user id={2};Password={3};Port={4};"

Please fill the appropriate data instead of {0} {1}...

server is the hostname or ip

database is the MySql schema or the database name that is being used

You can omit the Port.

then try connection .Open and see if you can connect.

The rest is pretty similar to all ADO.NET operations, Adapter, DataSet, ExecuteNonQuery...

Hope this helps.

Re: Can't connect to the MySQL database online. Please help!

Thanks ralph

This is my string. This ok?

<add name="ConnectionString"

MySqlConnection connection = new MySqlConnection

("database=zebradat;server=243.131.32.34;user id=zebradatadmin;Password=3vex491;")

providerName="MySql.Data.MySqlClient"/>

</connectionStrings>

Still not able to connect am afraid.

I get the runtime error

Server Error in '/' Application.

Runtime Error

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="Off"/>
    </system.web>
</configuration>

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.

<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
    </system.web>
</configuration>

Re: Can't connect to the MySQL database online. Please help!

ok 3 things.

1. Please tell me you did not write your password in your post :) If you did, I suggest you change your password, as hackers can get to this post easily.

2. Before you add your connection string to your Web.Config. use Use it as a string directly in the code that I sent you last. In other words instead of writing it in web.config, pass it as a parameters to the MySqlConnection.

3. Edit your Web.Config file to allow you to see errors remotely, follow the instructions on the page (setting the custom errors to off instead of RemoteOnly)

Re: Can't connect to the MySQL database online. Please help!

Thnx for the prompt reply.

re; pt. 1. No i didn't. I am a noob but not that much of a noob : ) I've set that up as per"This is what i got form my host(will change security sensitive stuff):

Your MySQL database settings
Server Name:    mysql-913
Server IP Address:      243.131.32.34
Database Name:          zebradat
Database Username:      zebradatadmin
Database Password:      3vex491"

re; pt.2. Pass it as a param. in the assembly of/ or the page itself on which data is supposed to be displayed/pulled in? or? And is this C#?.. since I'm using VB. Could you please copy and paste the whole string from somewhere.. changing/removing the security sensitive stuff.. obviously ;)

re; pt.3. you mean setting customErrors mode="Off" ? I've done that some time ago...

Thank you ralph

Re: Can't connect to the MySQL database online. Please help!

pt2: Well yes, I am assuming you know how to work with ADO.NET right? Do you know how to use SqlConnection? I was assuming so and just providing you with the fill in the blanks between MS Sql classes and MySql classes, if you are not very familier with ADO.NET Google up some simple samples on how to connection to a database through asp.net using MS SQL and when you understand that you will see the MySql solution easily. Sorry about C#, yes if I knew VB I would write that for you, but you are gonna do the translation yourself.

As for the code, I already gave it to you several times :) but I guess you are misunderstanding it as a connection string to be put in Web.Config

here it is again, remember this is your C# Code

MySqlConnection connection = new MySqlConnection ("database=zebradat;server=243.131.32.34;user id=zebradatadmin;Password=3vex491;");

connection.Open(); // your connection should open now.

pt3: yes that is correct, but the error that your site is giving you indicates that it is not put to off, double check it.

Regards.

Re: Can't connect to the MySQL database online. Please help!

No, I'm not familiar w ado.net I'm afraid : ( Will research...

As for the customErrors mode="Off" .. it is off.. but I know what you mean. It was showing me different(more specific) error messages before it's just that it displyed this one after i entered &uploaded the above (<add name="ConnectionString" MySqlConnection connection = new MySqlConnection("databas.........) as the connection string.. LOL

Thank you so much for all your help ralph! Will let you know how I get on...

Re: Can't connect to the MySQL database online. Please help!

Sure, you can find a lot of resources on the net for this and later on if you need further help, do not hesitate.

Re: Can't connect to the MySQL database online. Please help!

Sure, you can find a lot of resources on the net for this as the topic is way too big for a post.

And later on if you need further help, do not hesitate.

Re: Can't connect to the MySQL database online. Please help!

I understand ralph. Thank you for all the help so far

Re: Can't connect to the MySQL database online. Please help!

Hi Ralph,

Hope you well.

I've been playing around. Discovering new things re; ADO.net.. still fuzzy but getting there..

This is the error I've been getting:

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=5.1.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

Source Error:

Line 27: 		<compilation debug="true" strict="false" explicit="true">
Line 28: 			<assemblies>
Line 29: 				<add assembly="MySql.Data, Version=5.1.5.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/></assemblies></compilation>
Line 30: 		<pages>
Line 31: 			<namespaces>

Source File: e:\domains\m\mangonet.ourwebnet.com\user\htdocs\web.config Line: 29

Assembly Load Trace: The following information can be helpful to determine why the assembly 'MySql.Data, Version=5.1.5.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].

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

Is this something to do with MySql .net connector or??

Re: Can't connect to the MySQL database online. Please help!

Is this error from the website on the same computer that you are developing the application? I mean did you deploy it on another machine?

Try removing the reference to MySql.Data.dll in your project and readding it. From the way I see it, this is just a VS mess up.

Let me know.

Re: Can't connect to the MySQL database online. Please help!

It's the error on the remote server(host).. not local.

Will try removing the MySql.Data.dll reference and uploading.. Thanks

Re: Can't connect to the MySQL database online. Please help!

Make sure you have the MySql.Data.dll on the server as well (in the bin directory) or else it will give you the above error.