ODBC cannot connect to localhost


  1. geob
    Posts : 35
    10 Windows 7 Pro 32-bit
       New #1

    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 Computer
    Quote Quote

  3. geob
    Posts : 35
    10 Windows 7 Pro 32-bit
    Thread Starter
       New #2

    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 Computer
    Quote Quote

 

  Related Discussions
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...
ODBC Configuration
in General Discussion

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...
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...
Localhost not working
in Network & Sharing

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,...
odbc
in Software

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?
Our Sites
Site Links
About 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 15:40.
Find Us