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.]
Thanks.
g
[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.]
Thanks.
g
My Computer
- Computer type
- PC/Desktop
- Computer Manufacturer/Model Number
- HP 6730s laptop
- OS
- 10 Windows 7 Pro 32-bit
- CPU
- Intel P7370
- Motherboard
- Base Board 30E8; KBC Version 94.1D
- Memory
- 4GB
- Graphics Card(s)
- Mobile Intel(R) 4 Series Express Chipset Family (Microsoft C
- Sound Card
- SoundMAX Integrated Digital HD Audio
- Monitor(s) Displays
- Generic PnP Monitor (per Device Manager)
- Screen Resolution
- 1280 x 800 x 32 bits (4294967296 colors) @ 59 Hz
- Hard Drives
- WDC WD5000BEVT-60ZAT1 ATA Device: 465.76 GB
- PSU
- HP 6730s
- Case
- HP 6730s
- Cooling
- HP 6730s
- Keyboard
- HID Keyboard Device (per Device Manager)
- Mouse
- Synaptics PS/2 Port TouchPad
- Internet Speed
- varies
- Antivirus
- Norton Internet Security
- Browser
- Firefox 47
- Other Info
- Where no detailed information from SystemInfo is available HP 6730s has been entered.