Solved

System DSN in Windows 7

Posted on 2010-09-15
5
906 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
  • 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Google chrome pages randomly timing out 3 48
block folder inheritance 4 35
Run time Error 4 35
CPU at 100% usage, why? 27 84
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
OfficeMate Freezes on login or does not load after login credentials are input.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
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…

863 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now