Re: Unable to decipher ODBC trace log

Yes, I tried localhost, %, ip numbers, remote host, with and without
password. I can connect locally fine (on the server), but not from the
client. Hence I did the trace to see if that would help. I do not know
enough about mySQL for it to be of any assistance to me, so I was hoping
some gurus out there would drop a little nugget for me.

On Nov 14, 2007 10:15 AM, Imran Abizar <[email protected]> wrote:

> Charles,
>
> There are two type of grants: localhost and others. Did you issue a
> GRANT ALL statement for both? Refer to
> http://kb.synametrics.com/FrontController?operation=1&id=49
>
>
> Best regards,
> Imran.
>
> Charles Schultz wrote:
> > Trying to use ODBC (windows) to connect to MySQL (Linux). The trace file
> > shows the following:
> >
> > odbcad32        cec-dc8    ENTER SQLDriverConnectW
> >         HDBC                00A215E8
> >         HWND                00000000
> >         WCHAR *             0x74329A38 [      -3] "******\ 0"
> >         SWORD                       -3
> >         WCHAR *             0x74329A38
> >         SWORD                        2
> >         SWORD *             0x00000000
> >         UWORD                        0 <SQL_DRIVER_NOPROMPT>
> >
> > odbcad32        cec-dc8    EXIT  SQLDriverConnectW  with return code -1
> > (SQL_ERROR)
> >         HDBC                00A215E8
> >         HWND                00000000
> >         WCHAR *             0x74329A38 [      -3] "******\ 0"
> >         SWORD                       -3
> >         WCHAR *             0x74329A38
> >         SWORD                        2
> >         SWORD *             0x00000000
> >         UWORD                        0 <SQL_DRIVER_NOPROMPT>
> >
> >         DIAG [HYT00] [MySQL][ODBC 3.51 Driver]Access denied for user
> 'sac'@'
> > nnn.nnn.nnn' (using password: NO) (1045)
> >
> >
> > I have verified that the grants are setup properly (have tried a number
> of
> > variations as well), the Linux firewall is open, and all appropriate
> names
> > can be resolved. What does the odbc trace log tell me?
> >
> >
>



-- 
Charles Schultz