On a Win7Pro-32 system running in XP mode, I'm trying to use ODBC (v5.1.9) to connect to a MySQL db on localhost. Interestingly, when using a username with remote host privileges I am able to connect to a remote db - this tells me ODBC is installed and working properly. Yet when I try to connect to localhost with a user DSN using a login that works on the XP mode host I get a Connection failed error. So there's clearly something about ODBC to localhost. Any solution available?
[Why ODBC in XP Mode you might ask? I'm trying to develop an Excel macro in XL2003 for a client. This is my attempt to replicate their environment without creating a mess of conflicts in my own working environment.]