Re: Unable to decipher ODBC trace log

After doing a little more reading, I think I may have resolved this. I had
multiple entries in "user" for my various tests, not realizing that there
was an order of precedence. After dropping the user and regranting, I was
able to connect properly.

thx

On Nov 14, 2007 10:20 AM, Charles Schultz <[email protected]> wrote:

> 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




-- 
Charles Schultz