access denied to user

I am using mysql odbc driver ver. 3.51

On several machines I have installed the odbc driver and successfully connected them to a mysql database where the database admin used the grant statement:

grant all on pdadata.* to pdauser@"172.xx.xx.%" identified by 'xxxxx';
(of course the 2 xx's are integers in our ip range and xxxxx is the password)

However, on several machines properly in the ip range, I get the error
'Access denied for user 'pdauser'@'172.xx.xx.%'

First thing is, the database admin thinks it is odd that the ip address returned by the error is the ip address w/wildcard used in the grant statement, not the ip address of the connecting user.

Then he said 'Lot's of luck, hope you find the answer' as he left the cubical of the user I was trying to connect.

Any ideas?

Thanks in advance for any help.

Fred


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]