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)
- Data Source Name
- Server
- User
- Password
- Database
Error message:Connection Failed:[HY000][Mysql][ODBC5.1 Driver]Can't connect to mysql server on 10.93.199.253(10060)
- i given grant privileges to the database for the user "lakshmi".
- Turned on the firewall
- Both the machines are windows xp
- LAN
- dynamic ip address
please help me out
Regards,
santhanalakshmi