My ODBC Error

[harvillo]

Mysql Running: MySQL 3.23.52
Local Computer is XP

I'm having problems running MyODBC from my remote system. I'm simply trying to connect and I'm receiving a mysql error Cannot connect to mysql server on 'my server IP' (10060). All of my password/priveleges info is correct in mysql but, as I am new to this, I am 95% this is an operator error issue as opposed to a mysql error. I've read in various articles about remote access being enabled but am not sure if this is a problem or where to enable such a setting.

Question..if I am able to get this running will I be able to update mysql data from my local machine or is the ODBC a one way connection where I will only receive the data?

Thanks

[PHPdev]

You need to make sure you have the perms set so that the user you are trying to access with can access from the IP of your XP box.

Look at your User or DB table in the MySQL database, and one of the entries has the IP of your XP box in the HOST section.

ODBC is a full connection to the database. Meaning it is the same as if you were working on the machine with the MySQL server. The issue of permissions comes to what permissions you assign to the user you are conneting via ODBC with...

Hope this helps...

PHPdev

[marconi8]

all my user permisions is installed normally,
user have hosts permisions like = ' any hosts '

mysql works normally, all is ok. but i still cannot connect remotely

....................

maybe you nwo some solutions ??

thanks////