[cornetto456]

Hi i got some problems with my connection to a MySQL database so this is my code:

 Dim conn As MySqlConnection
        'connect to DB
        conn = New MySqlConnection()
        conn.ConnectionString = "server=**¨¨**¨¨.com; user id=****¨¨¨***; password=***¨¨¨**¨¨**; database=**¨¨**¨¨**¨¨"
        'see if connection failed.
        Try
            conn.Open()
        Catch myerror As MySqlException
            MsgBox("Error:" & myerror.ToString)
        End Try
        'sql query
        Dim myAdapter As New MySqlDataAdapter

        Dim sqlquery = "SELECT * FROM login WHERE username='" + txtuser.Text + "' AND password= '" + txtpass.Text + "'"
        Dim myCommand As New MySqlCommand()
        myCommand.Connection = conn
        myCommand.CommandText = sqlquery
        'start query
        myAdapter.SelectCommand = myCommand
        Dim myData As MySqlDataReader
        myData = myCommand.ExecuteReader()
        'see if user exists
        If myData.HasRows = 0 Then
            MsgBox("Invalid username and/or password!")
        Else
            MsgBox("Login Accepted!")
            Form2.Show()
            Me.Hide()
        End If

i got this error:MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. ---> System.Exception: Exception of type 'System.Exception' was thrown.
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Go_For_Code_Share.Form1.Button1_Click_1(Object sender, EventArgs e) in C:\Users\Arno Cornette\AppData\Local\Temporary Projects\Go For Code Share\Form1.vb:line 15

Hope you can help

Thanks


Arno Cornette

[TADS]

If this is a mysql on a webhost, you need to set the host to accept % for accepting ALL incoming ip's most mysql databases dont accept incoming connections other then localhost

try that 1st

[cornetto456]

oke thanks for that but where do i need to put the % in the connection string ???


Thanks
Arno(Cornetto456)

[TADS]

you dont... you have to do that server side... IF you are using cpanel go into Remote mysql and you place add % host

[cornetto456]

im not a paying member and im also not willing to pay :S

but isn't there other website that are hosting free mysql database

my host is for websites


or dosn't exist somthing like a host that only host mysql datbase ???

thanks

[TADS]

for your web hosting are you using cpanel?

if so go to cpanel and click Remote mysql


image from cpanel

if you are not using cpanel you will have to google how to set incoming connect on mysql database

hope this helps

Kev

This post has been edited by TADS: 08 February 2011 - 11:31 AM

[cornetto456]

i found a webhost that use cpanel so thanks i gona try it

Thanks
Arno(cornetto456)

[cornetto456]

TADS, on 08 February 2011 - 11:31 AM, said:

for your web hosting are you using cpanel?

if so go to cpanel and click Remote mysql


image from cpanel

if you are not using cpanel you will have to google how to set incoming connect on mysql database

hope this helps

Kev

What if i don't have that function ???

Thanks

Arno(Cornetto456)