Improve company productivity with a Business Account.Sign Up

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

System DSN in Windows 7

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
fhenreaux
Asked:
fhenreaux
  • 4
1 Solution
 
esp-projectsCommented:
Did you create the System DSN whilst logged in as an administrator?  If not, can you try doing that?
0
 
fhenreauxAuthor Commented:
Yes, my account has the administrator right.
0
 
fhenreauxAuthor Commented:
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
 
fhenreauxAuthor Commented:
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
 
fhenreauxAuthor Commented:
Hi

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

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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