Unable to decipher ODBC trace log
"Charles Schultz" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
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