santhanalakshmi -2 Junior Poster in Training

Hi,
I have installed the mysql connector ODBC 3.51 on the remote machine as well as on the local machine.

Mysql Connection with VB.Mysql Connection on the local machine its working fine.

cn1.ConnectionString = "driver={MySQL ODBC 3.51 Driver};server=localhost;database=dummy;data source=dum;Option=3"

When i trying to connect the mysql from the remote machine to my local machine .......i got an error message

Control Panel--->Administrative Tools --->ODBC ---> system DSN ---> ADD --> mysql connector 3.51

what should be filled in the following text box ?
(both the machine :the local machine and the remote machine)

  1. Data Source Name
  2. Server
  3. User
  4. Password
  5. Database

Error message:Connection Failed:[HY000][Mysql][ODBC5.1 Driver]Can't connect to mysql server on 10.93.199.253(10060)

  1. i given grant privileges to the database for the user "lakshmi".
  2. Turned on the firewall
  3. Both the machines are windows xp
  4. LAN
  5. dynamic ip address

please help me out

Regards,
santhanalakshmi

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.