Windows 7 64 bit - Data Sourse ODBC problems

Posted on 2012-09-09
Last Modified: 2012-09-09

I am running Windows 7 Ultimate 64 bits.

When I run the Administrative Tools, Data Source (ODBC),
I am missing 98 percent of all my ODBC drivers and my connection do not work most of the
I think the file being selected is the C:\windows\system32\odbcad32.exe

In order to see all my drivers I have to go to
c:\windows\SysWOW64\odbcad32.exe and then I can see them all.

Can anyone let me know how do I make Administrative Tools, Data Source (ODBC), pick up all my driver the same way c:\windows\SysWOW64\odbcad32.exe does or if there is a
setting that I need to change so the computer uses the c:\windows\SysWOW64\odbcad32.exe as the default system settings.

Your help is very much appreciated.
Question by:DPP2011
    LVL 82

    Expert Comment

    by:Dave Baldwin
    Most ODBC drivers are 32-bit and c:\windows\SysWOW64\odbcad32.exe is the place to find them.  Though it is confusing, the drivers found in C:\windows\system32\odbcad32.exe are the very few 64-bit drivers.

    Author Comment

    Thank you,
    So, if I set up a connection on c:\windows\SysWOW64\odbcad32.exe, it should work
    all the time?
    LVL 82

    Expert Comment

    by:Dave Baldwin
    'odbcad32.exe' is just the interface to the drivers that are required.  I don't know why they named two different versions the same.  To connect to a particular program or database, you have to use the version that supports it.  Like I said, it appears that most ODBC drivers are 32-bit.  This search brings up many links to the question and answers.
    LVL 10

    Accepted Solution

    Just a tip, you can create a new shortcut to the 32-bit version in your Administrative tools.  What I did was just copied the "Data Sources (ODBC)", edited the new copy to point to the right place, then renamed it to "Data Sources (ODBC) (32-bit)".

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Ever notice how you can't use a new drive in Windows without having Windows assigning a Disk Signature?  Ever have a signature collision problem (especially with Virtual Machines?)  This article is intended to help you understand what's going on and…
    When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
    This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…
    This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now