Dear VBers.
sedikit trouble nih ttg konek VB n MySQL. Misal di suatu Form :
Dim Con As New ADODB.Connection
Dim rs As New ADODB.Recordset
CON.Open "DRIVER={MySQL ODBC 3.51
Driver};SERVER=169.10.110.1;UID=root;PWD=wajdi;DATABASE=hrd;" _
& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 163841
CON.CursorLocation = adUseClient
ketika di-Run Error Message-nya :
Run-time error '-2147467259 (8000-4005)':
[MySQL[ODBC 3.15 Driver]Host 'WAJDI' is not allowed to connect to this MySQL
Server
Tapi ketika koneksinya diganti SERVER=localhost bisa jalan normal (Program
Desktop). Apa salah syntax ato gmn ya. Disini maksudnya SERVER={IP ADDRESS} tak
ganti biar klo program diinstal di komputer lain bisa langsung konek DB coz
DB-nya ada di IP Address itu.
Klo ada yang tau mohon bantuan rekan2 smua ya. Thanks.
