Link to home
Start Free TrialLog in
Avatar of fhenreaux
fhenreauxFlag for Belgium

asked on

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.
Avatar of esp-projects
esp-projects
Flag of United Kingdom of Great Britain and Northern Ireland image

Did you create the System DSN whilst logged in as an administrator?  If not, can you try doing that?
Avatar of fhenreaux

ASKER

Yes, my account has the administrator right.
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 !!!  
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?
ASKER CERTIFIED SOLUTION
Avatar of fhenreaux
fhenreaux
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial