Re: Unable to decipher ODBC trace log

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?
>
>   

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