i have installed mysql on Windows 2003 Server and when i try to connect from vb to mysql from the machine itself connects instantly, but when i try to connect from another machine in the network it takes 16 seconds to connect. It takes 16 seconds to connect from the Internet.
I have tried to connect via windows Data resources (ODBC) the same thing happened.
I am using MySQL ODBC 3.51 Driver to connect. I think i need to make a few configuration changes, but i dont know what to change.
(I have tried both Rdo and Ado connection and the result is the same)
Please help me to reduce the connection time.