Halo Rekan-rekan, mau tanya nih,
saya ada coba test koneksi vb ke MySQL
kira-kira begini script nya:
Dim Conn As ADODB.Connection
Dim Rs1 As ADODB.Recordset
Set Conn = New Connection
Conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
"SERVER=localhost;" _
"DATABASE=MyData;" _
"UID=root;" _
"PWD=MyPassword;" _
"OPTION=3"
Conn.Open
Kalau "SERVER=localhost;" (Berjalan Lancar)
Pertanyaannya,
kok kalau server kita ganti dengan IP Komputer, jadi nga mau ya..?
misalnya: 192.168.217.1
kalau "SERVER=192.168.217.1;" (ERROR DAH.. Y_Y)
Bunyi errornya seperti ini:
Run-time error '-2147467259(80004005)
[MySQL][ODBC 3.51 Driver]Host 'KompGue' is not allowed to connect to
this MySQL Server
tapi kalau di ganti 127.0.0.1 mau.
Mohon bimbingannya,setting mana yg salah/kurang ya?
Rgds
vb-Beginner
