MySQL <-> VB.net issues

[new_future]

Hello everyone,

I'm trying to set a connection between my vb.net application and my MySQL located on mysql-starka.x10hosting.com
The issue is, that I can't seem to find a good tutorial explaining it, and if i do, he asks me for IP, port etc. which I don't have (or see on the phpmyadmin).

If anyone knows how to do it, please respond a.s.a.p. since I really need it.

Yours sincerely, Anasky.

[thegriff]

Tutorials do seem a bit useless - I had to work out most of it myself, with bits of google everywhere.

You have the mySql address, which is good: mysql-starka.x10hosting.com but it won't work - see later under web.config!

Have you got the mySql Connector? (the bit that comes in two ASP.NET assemblies mysql.Data.dll and mysql.web.dll) If so, then copy the two DLLs to the "/public_html/bin" folder in your webspace.

Have you set up a database in phpMyAdmin? If not, create a simple on for testing.

Have you set up a user for your databases, and allowed them full access rights to your test database? (phpMyAdmin again).

Edit your web.config on the server, and make it look lijke this:

<?xml version="1.0" ?>
<configuration>
  <appSettings />
  <connectionStrings>
    <add name="LoginDatabase" connectionString="server=mysql-chopin.x10hosting.com;database=XXX_testing;user id=DATABASEUSER;password=PASSWORD"/>
  </connectionStrings>
  <system.web>
    <customErrors mode="Off" />
  </system.web>
  <system.net>
    <mailSettings>
      <smtp deliveryMethod="network">
        <network port="26" />
      </smtp>
    </mailSettings>
  </system.net>
</configuration>

Replace the XXX with your x10hosting userid - I am guessing "starka", replace the DATABASEUSER and PASSWORD with the user info you set up in phpMyAdmin

The following code is C#, but it should be easy to translate to VB:

string strConnect = ConfigurationManager.ConnectionStrings["LoginDatabase"].ConnectionString;
MySqlCommand cmd = new MySqlCommand("SELECT Role FROM UserInfo WHERE userID = @ID");
cmd.Parameters.AddWithValue("@ID", userId);
MySqlDataReader reader = null;
try
{
cmd.Connection = new MySqlConnection(strConnect);
cmd.Connection.Open();
reader = cmd.ExecuteReader();
if (reader.Read())
{
this.role = (UserRole)reader["Role"];
}
catch (Exception ex)
{
thrownewException(cmd.CommandText + "\n" +
ex.Message, ex);
}
finally
{
if (reader != null)
{
reader.Close();
}
if (cmd.Connection != null)
{
cmd.Connection.Close();
}
}

This is lifted directly from a working routine, so it should be fine.

Make sure you have installed mySQl on your development machine, and set the connection string in the local web.config to select that (probably via "localhost" rather than "mysql-chopin.x10...")

Any probs, let me know!

[xav0989]

Simply to add some to the previous post, for the database creation, do not use phpmyadmin, but go directly through cPanel. As for the database username, use cPanel-username_database-username