[unixODBC-support] trouble with mysql driver on mono
nick.gorham at easysoft.com
Wed May 12 14:47:13 BST 2010
Martin Evans wrote:
> Nick Gorham wrote:
>> James Smith wrote:
>>> Whether this has anything to do with the fact that the test program
>>> doesn’t appear to open the ‘odbcinst.ini’ file at any point I don’t know.
>> With respect, I don't think you are looking hard enough at the logs you
>> sent. In both cases the socket opens, and is written, but a clue can be
>> seen in what comes back.
>> "[pid 9291] 10:28:30.953245 read(3, "E\0\0\2\377\25\4#28000Access denied
>> for u"..., 16384) = 73"
>> Looks to me like the MySQL driver isn't sending the correct user and or
>> password down. I would check the server logs to see what its sending,
>> but that looks to me like the problem you are having.
> I think that message can be something like "Access denied for user X at
> 192.168.0.10" so it could simply be that your username/password are
> correct but you have not set the access permission in your mysql
> database to allow connections your ubuntu box IP address.
Yep, but as isql connects, then the user and password being sent must
not be what is expected.
More information about the unixODBC-support