Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1256
  • Last Modified:

System DSN Missing in Windows 7

Hey guys, have a weird problem. I have 2 machines running windows 7 Ent.  I create a DSN and it shows up and tests fine on the System DSN tab.  When I run an access database that retrives the windows registry DSN's they don't show up on the other machine, but work fine on the first.
The files are being run as MDE's.
The strange thing is that when I tried to create a new DSN through Access 2007 and saved it, the application saw the DSN and everything worked fine but the DSN did not show up on the odbca32 in any of the folders. Am I missing something or is this a known bug. Still does not make sense since they are both windows 7 machines.
0
dsulkar
Asked:
dsulkar
  • 4
  • 3
1 Solution
 
sunezapaCommented:
There is 32bit drivers and 64bit drivers.
the 64bit ODBC manager ONLY show the 64bit drivers.
The two ODBC managers has identical names, but they are different.
Yes - confusing - but not a bug, just a "Microsoft Speciality" :-D
0
 
sunezapaCommented:
ODBC Managers: "%windir%\system32\odbcad32.exe" AND identical named "c:\Windows\SysWOW64\odbcad32.exe".
The one in the SySWOW64 folder is the 32bit thing - despite the 64 in the foldername. Weird ;-)
0
 
dsulkarAuthor Commented:
Thanks, that makes perfect sense, I have a feeling the desktop icon i created on the other machine is from the WOW folder. I will try it in the morning. Thanks
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
dsulkarAuthor Commented:
OK a little confused, which one is what? it looks like the c:\Windows\SysWOW64\odbcad32.exe is the one that is working
0
 
sunezapaCommented:
the wow thing is 32 bit.
both are working, but the drivers needed is depending of what program to use them: 32bit Office programs use 32bit drivers, and so...
0
 
dsulkarAuthor Commented:
Thanks very much, this was exactly what the problem was.
I appreciate the quick answer.
0
 
dsulkarAuthor Commented:
Just perfect, this is why I love this site
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.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now