i use this code
---------------------
in module
-----------
Imports CoreLab.MySql
Module basConect
Public conn As New MySqlConnection("User ID=root;Password=;Host=192.168.0.5;Port=3306;Database=test;")
Public Sub ConectMySQL()
Try
conn.Open()
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
ConectMySQL()
End Sub
End Class
i tried this on visual studio .net 2005. but when i try this.it says "host 'wm_myname' is not allowed to connect to this mysql server".
i use 192.168.0.5 for my wifi ip address in my computer and 192.168.0.4 in my pocket pc.is 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\system_SR_enu.cab" ".can you give me explanation why it is always show
thank you...
connection problem with mobile device
the next problem
i have already put this command in mysql console
"grant select,insert,update,delete,create,drop on klinik.* to 'root'@'192.168.0.4' identified by 'mysql'; "
and
"set password for 'root'@'192.168.0.4'=old_password('mysql');"
i use 192.168.0.4 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
"grant select,insert,update,delete,create,drop on klinik.* to 'root'@'192.168.0.4' identified by 'mysql'; "
and
"set password for 'root'@'192.168.0.4'=old_password('mysql');"
i use 192.168.0.4 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