I am trying to access a Mysql Server through Lan using VB6
using ADODB connection

db.Open "DRIVER={MySQL ODBC 5.1 Driver};DATABASE=xxxx;SERVER=;USER=root ;PASSWORD=xxxx;OPTION=3;"

it is giving error [Mysql][ODBC 5.1 Driver]host couldn't connect to the Mysql Server

My Server IP is :
user is: root

Firewalls are turned off....
Might be i need to allow lan access in my sever Mysql. I dont know how to do it

Can anyone give me a solution to this problem..