Windows 7 Forums


Windows 7: ODBC cannot connect to localhost

25 Feb 2012   #1

Windows 7 Pro 32-bit
 
 
ODBC cannot connect to localhost

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
My System SpecsSystem Spec

25 Feb 2012   #2

Windows 7 Pro 32-bit
 
 

Well, DUH! The server isn't on localhost! It is, however, at the IP address of the XP Mode host. So when that address is fixed and entered in the ODBC configuration a connection is possible.

No wonder my hair is now white!

g
My System SpecsSystem Spec
Reply

 ODBC cannot connect to localhost problems?



Thread Tools



Similar help and support threads for: ODBC cannot connect to localhost
Thread Forum
ssh: connect to host localhost port 22: Connection refused Software
Solved Windows 7 x64 and localhost to web Network & Sharing
Win7 x64 / Office 2010 - ODBC connect error Microsoft Office
Localhost not working Network & Sharing
odbc Software


All times are GMT -5. The time now is 06:40 PM.


Seven Forums Android App Seven Forums IOS App Follow us on Facebook

Windows 7 Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32