need help (vb6 + mysql)

database connection

Set cn = New ADODB.CONNECTION

Set cn = New ADODB.CONNECTION

cn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=192.168.1.229;" _
& "DATABASE=ssmpc_database;" _
& "UID=root;PWD=ssmpc; OPTION=3"
cn.Open

on the computer that i am working on, the connection is working.
but when i try to put the vb program on another computer
message appears ("cant connect to mysql server on 192.168.1.229")

how to access mysql connection remotely?

Checkout my project here.

Edit:

You will also need to configure the server to allow access to the database from your computer, instructions for this can be found in post #8.