This is only happening on one person's machine. If I go to a different
machine on the same subnet and use the same login and password to
connect to the same database when setting up a user DSN using MyODBC
3.5.10 it works just fine.
Over the weekend on this one machine, however, I started getting an
access denied error with connecting. It appeared in Access 2002, but it
also happens when using the "Test" button on the MyODBC connection setup
dialog.
Attached is the snippet of the trace. It almost seems like the outgoing
ODBC connection was blocked or something. The rest of the network works
for the user (web, ssh, Citrix).
Can anyone think of a reason why just this one WinXP machine would
suddenly have trouble connecting? Or maybe some suggestions for how to
track down where the problem is occuring? I can do a tcpdump on my
MySQL server to see if it is making the connection, but other than that
I am not sure what to do on the Windows side to try to figure it out.
Oh, I haven't initiated any group policy changes or installed any
firewall software. The machine was turned off all weekend. 8)
Thanks,
Alan
----------------------------
odbcad32 918-91c EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 00B41540
SQLHANDLE * 0x0006D574 ( 0x00b415e8)
odbcad32 918-91c ENTER SQLDriverConnectW
HDBC 00B415E8
HWND 00000000
WCHAR * 0x00B07310 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x00B07310
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
odbcad32 918-91c EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 00B415E8
HWND 00000000
WCHAR * 0x00B07310 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x00B07310
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [HYT00] [MySQL][ODBC 3.51 Driver]Access denied for user: 'dbuser [at] 123.45.67.89' (Using password: YES) (1045)
odbcad32 918-91c ENTER SQLGetDiagRecW
SQLSMALLINT 2
SQLHANDLE 00B415E8
SQLSMALLINT 1
SQLWCHAR * 0x0006D2D4 (NYI)
SQLINTEGER * 0x0006D518
SQLWCHAR * 0x00B41A90 (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0006D528
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
