[unixODBC-support] trouble with mysql driver on mono

Martin Evans martin.evans at easysoft.com
Wed May 12 15:21:03 BST 2010


Nick Gorham wrote:
> 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.
> 

Thread was getting so long I missed that isql bit.

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com


More information about the unixODBC-support mailing list