fhenreaux
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.
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.
Did you create the System DSN whilst logged in as an administrator? If not, can you try doing that?
ASKER
Yes, my account has the administrator right.
ASKER
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 !!!
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 !!!
ASKER
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.