i write the code in VB to connect MySQL database. thia code able to connect at local PC, but when i install the program to other PC, it not able to connect MySQL Server. Please how what should i modify on the code or MySQL setting that to enable my to connect MySQL Server from other PC? Set conn = New ADODB.Connection conn.C _ & "SERVER=localhost;" _ & "DATABASE=myerp;" _ & "UID=root;" _ & "PWD=zoomic;" _ & "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384 conn.CursorLocation = adUseClient conn.Open
Instead of SERVER=localhost Substitute with the IP and domain name of the My SQL server. Also ensure that that MySQL server had the port 3066 open.
Do a google on telnet client there is a lot available or you can use putty http://www.chiark.greenend.org.uk/~sgtatham/putty/