Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.



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





Thread Tools



Similar help and support threads for2: 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
ODBC Configuration General Discussion
Win7 x64 / Office 2010 - ODBC connect error Microsoft Office
odbc Software
ODBC on Virtual XP not available on WIN 7 Drivers
ODBC Issue Network & Sharing

Our Sites

Site Links

About Us

Find Us

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

All times are GMT -5. The time now is 10:40 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

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 33