connection problem with mobile device

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Posts: 3
Joined: Mon 30 Apr 2007 05:38

connection problem with mobile device

Post by arif_amm » Tue 01 May 2007 01:26

i use this code

in module
Imports CoreLab.MySql

Module basConect
Public conn As New MySqlConnection("User ID=root;Password=;Host=;Port=3306;Database=test;")
Public Sub ConectMySQL()

MsgBox("Conect", MsgBoxStyle.Information, "")
Catch ex As MySqlException
MsgBox(ex.Message, MsgBoxStyle.Critical, "")
End Try

End Sub
End Module

in form

Public Class Form1

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
End Sub
End Class

i tried this on visual studio .net 2005. but when i try says "host 'wm_myname' is not allowed to connect to this mysql server".
i use for my wifi ip address in my computer and in my pocket there something i must set so mysql in my computer alowed me to access the database?i use ipaq 1950 which has windows mobile 5 installed
there is another ask.when i deploy my project,there is always a message says "post-deploy error 0x80070005 returned after calling "windows\wcload.exe /noui \windows\" ".can you give me explanation why it is always show

thank you... :D

Posts: 3
Joined: Mon 30 Apr 2007 05:38

the next problem

Post by arif_amm » Tue 01 May 2007 06:14

i have already put this command in mysql console

"grant select,insert,update,delete,create,drop on klinik.* to 'root'@'' identified by 'mysql'; "


"set password for 'root'@''=old_password('mysql');"

i use because i think that my wifi ip address for pocket pc.

and now it's work.
my connection success and when i trying to do insert,update and delete,it is working to :D

Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 07 May 2007 11:22

Well done.

Post Reply