Solved

System DSN in Windows 7

Posted on 2010-09-15
5
912 Views
Last Modified: 2012-05-10
Hi

I have a problem with windows 7.
I have created a System DSN ODBC to access my database. When I try to connect that database via the System DSN, that doesn't work. But if i create a User DSN, it works. I don't to create a DSN for each user who needs to access that DB. It works for XP but not with W7.
So, can you tell me how to solve my problem?

Thanks.
0
Comment
Question by:fhenreaux
[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
5 Comments
 
LVL 3

Expert Comment

by:esp-projects
ID: 33683078
Did you create the System DSN whilst logged in as an administrator?  If not, can you try doing that?
0
 

Author Comment

by:fhenreaux
ID: 33688928
Yes, my account has the administrator right.
0
 

Author Comment

by:fhenreaux
ID: 33692406
I've created system dsn with the Domain administrator. When created, this dsn is visible in the odbc system dsn list.
When I open MS Access database and try to link a table via odbc, I don't see any system dsn. There is a button to create one in access.
I created "MyDSN" via this button and when it is created, it is not visible in the Control panel.... ODBC... system dsn, but I can use it in the access DB (all users dsn and all System dsn created in access are listed) .

Strange !!!  
0
 

Author Comment

by:fhenreaux
ID: 33714364
Hi

And when I've created "MyDSN" with Access to do a test, I cannot delete it in the access ODBC panel !!!

Can anybody help me???? Is there something i'm doing wrong?
0
 

Accepted Solution

by:
fhenreaux earned 0 total points
ID: 33714595
Hi

Finally I found the answer, I have to execute  C:\Windows\SysWOW64\odbcad32.exe and now it works.

0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

751 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