mysql using vb.net?

I am not sure about what is going on down there, but if this is MSSQL, I would normally check with protocols, firewall

try this one. I am using this snippet to execute commands.

Imports MySql.Data.MySqlClient
Dim strConnString As String = "server=xxx.x.x.x;uid=user;pwd=password;database=xxx"
Dim objConn As New MySqlConnection(strConnString)

Public Function MyDataSet(ByVal strSQL As String) As DataSet
        Dim ds As New DataSet
        Dim mycmd As MySqlCommand = New MySqlCommand(strSQL, objConn)
        Dim ad As MySqlDataAdapter = New MySqlDataAdapter
        ad.SelectCommand = mycmd
        objConn.Open()
        ad.Fill(ds, "a")
        objConn.Close()
        Return ds
End Function

Best Regards, @iamsupergrasya

This is how I did it (using C#):

using System.Data.Sql;
using MySql.Data.MySqlClient;

        MySql.Data.MySqlClient.MySqlConnection dataConnection =  new MySql.Data.MySqlClient.MySqlConnection();
        dataConnection.ConnectionString = "Server = xx.xx.xxx.xxx; Database = dbNAME; Uid = userID; Pwd = password;";


        MySql.Data.MySqlClient.MySqlCommand dataCommand = new MySqlCommand();
        dataCommand.Connection = dataConnection;

        //tell the compiler and database that we're using parameters (thus the @first, @last, @nick)
        dataCommand.CommandText = ("INSERT INTO ...;");

        //add our parameters to our command object
        dataCommand.Parameters.AddWithValue("@recordId", dataString[0].ToString());
        ...

        try{
            dataConnection.Open();
            dataCommand.ExecuteNonQuery();
            dataConnection.Close();
        }catch (Exception x){
            Console.WriteLine(x.Message.ToString());
        }

I thought I might of had it originally in VB.Net but you "should" be able to convert this to VB fairly easily. If you still need help let me know. I will try to convert it tonight.

Let me know if it works for you.

UPDATE - VB.NET Code:

Dim dataConnection As New MySql.Data.MySqlClient.MySqlConnection()
dataConnection.ConnectionString = "Server = xx.xx.xxx.xxx; Database = dbNAME; Uid = userID; Pwd = password;"


Dim dataCommand As MySql.Data.MySqlClient.MySqlCommand = New MySqlCommand()
dataCommand.Connection = dataConnection

'tell the compiler and database that we're using parameters (thus the @first, @last, @nick) 
dataCommand.CommandText = ("INSERT INTO ...;")

'add our parameters to our command object 
dataCommand.Parameters.AddWithValue("@recordId", dataString(0).ToString())

Try
    dataConnection.Open()
    dataCommand.ExecuteNonQuery()
    dataConnection.Close()
Catch x As Exception
    Console.WriteLine(x.Message.ToString())
End Try

I used this converter tool (http://www.developerfusion.com/tools/convert/csharp-to-vb/) - So try this out.

Update - Answer from question on comment:

you can ping your site using the command prompt:

cmd.exe

Then in the command window type in the URL of your site. That will give you back the IP address of your site.