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
geob

10 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
geob

10 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
Thread Forum
ssh: connect to host localhost port 22: Connection refused
i am on windows-64 bit hp machne. i installed first latest cygwin(from local directory) to run hadoop on windows,but forgot to install tcp_wrappers pacakge. so i deleted everything in C drive related to cygwin,also .ssh folder & .bashrc.profile & installed again cygwin freshly. i follow this...
Software
ODBC Configuration
Background: We run this program at work called "Surgisource", it is a medical billing program of sorts. Most of our computers here run Windows XP 32bit and the software runs without fail. We have aproximately 10 Windows 7 machines of which only a few are running Surgisource. Of these few only 2 are...
General Discussion
Win7 x64 / Office 2010 - ODBC connect error
I have a MS Word application which uses a DSN-less connection to access a remote SQL database and which runs properly under a 32 bit OS. However, on my Windows 7 x64 systems with Office 2010 (32 bit) I get the following error when running the application: Data source name not found and no...
Microsoft Office
Localhost not working
Hi lads, New here. The name is Dave. I'm hoping someone can help me out. When I try to view http://localhost , i get nothing . Page not found. I have WAMP server installed. I just can't seem to figure out whats wrong. I've restarted all the services in WAMP and everything but still,...
Network & Sharing
odbc
could the odbc be used to tell windows how to surf the internet safely? to look for scripts in media/images/controls that could be malicious or cause unwanted or unintended behavior of hardware?
Software
Cant browse to localhost with iis 7 and 2 ips
Hi Guys, Yesterday I was able to browse to http://localhost and see my iis webserver, today I installed an extra ip address onto my machine so I now have 192.168.10.251 and 192.168.10.252 and now when I browse to localhost I get a forbidden message? Does anyone know how to get my iis back...
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 08:31.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App