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.
DPP2011Asked:
Who is Participating?
 
Purple_TidderConnect With a Mentor Commented:
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)".
0
 
Dave BaldwinFixer of ProblemsCommented:
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.
0
 
DPP2011Author Commented:
Thank you,
So, if I set up a connection on c:\windows\SysWOW64\odbcad32.exe, it should work
all the time?
0
 
Dave BaldwinFixer of ProblemsCommented:
'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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.