Hi
I have Mysql databse running on a windows 7 computer and this works fine. I now want to link to it form another computer using ODBC, I have loaded the ODBC connector for MySQl....
However when I try and connect I am getting and error message saying
"Connection Failed (HY000) ODBC 5 driver cannot connect to Mysql server on localhost 100061"
I have trawled the web for some answers, from one of thses I have added the port 3306 on the Mysql computer firewall. other than that I cannot find a solution. So 2 questions....
1. How do I PING the server form another computer, I can ping the computer name but notsure how to ping the actual DB connection.
2. Any ideas anyone jhow to connect with the ODBC, if I cant get this working then our databse is no good.
The settings are localhost, 3306, sa, password
Thanks
I have Mysql databse running on a windows 7 computer and this works fine. I now want to link to it form another computer using ODBC, I have loaded the ODBC connector for MySQl....
However when I try and connect I am getting and error message saying
"Connection Failed (HY000) ODBC 5 driver cannot connect to Mysql server on localhost 100061"
I have trawled the web for some answers, from one of thses I have added the port 3306 on the Mysql computer firewall. other than that I cannot find a solution. So 2 questions....
1. How do I PING the server form another computer, I can ping the computer name but notsure how to ping the actual DB connection.
2. Any ideas anyone jhow to connect with the ODBC, if I cant get this working then our databse is no good.
The settings are localhost, 3306, sa, password
Thanks