connection problem with mobile device

connection problem with mobile device

Postby 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=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... :D
arif_amm
 
Posts: 3
Joined: Mon 30 Apr 2007 05:38

the next problem

Postby 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'@'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 :D
arif_amm
 
Posts: 3
Joined: Mon 30 Apr 2007 05:38

Postby Alexey » Mon 07 May 2007 11:22

Well done.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL