asked on

Windows 7 64 bit - Data Sourse ODBC problems

Hello,

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
time.
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.

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.

DPP2011

ASKER

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

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 https://www.google.com/search?q=Microsoft+Windows+7+ODBC+drivers brings up many links to the question and answers.

ASKER CERTIFIED SOLUTION

Purple_Tidder

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial