Solved

System DSN Missing in Windows 7

Posted on 2011-02-17
7
1,212 Views
Last Modified: 2012-06-21
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
Comment
Question by:dsulkar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 3

Expert Comment

by:sunezapa
ID: 34922203
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
 
LVL 3

Accepted Solution

by:
sunezapa earned 500 total points
ID: 34922214
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
 
LVL 6

Author Comment

by:dsulkar
ID: 34923169
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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 6

Author Comment

by:dsulkar
ID: 34923238
OK a little confused, which one is what? it looks like the c:\Windows\SysWOW64\odbcad32.exe is the one that is working
0
 
LVL 3

Expert Comment

by:sunezapa
ID: 34925010
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
 
LVL 6

Author Comment

by:dsulkar
ID: 34932856
Thanks very much, this was exactly what the problem was.
I appreciate the quick answer.
0
 
LVL 6

Author Closing Comment

by:dsulkar
ID: 34932859
Just perfect, this is why I love this site
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Is doing tutor.com teaching in my situation advisable? 2 134
Problem to search 5 69
How can my static class become undefined?? 8 89
Cygwin - GNU GPL License 1 46
I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

733 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