Connecting to mySQL databse on some other server

[benliong]

I have maintained a mySQL databse at some remote server. Now I know that I have to use ODBC to connect to it in VB, and I have downloaded and installed mySQL drivers for ODBC data soruce in the control panel.

I'm however not sure of what to do next to connect to the database. Can someone teach me how ?

Thanks in advance.

peace.

--Ben.

In your ODBC connection, for the "MySQL host (name or IP):" put in the ip address of the remote MySQL server. If you get errors in connecting like "access denied" then you probably just need to set the permissions of your user account to allow access from remote hosts.
-Kerry