The difference between a System DSN and a User DSN in Windows 7
Posted on 2011-09-21
While signed in to a Windows 7 Pro 64-bit machine as an Admin, we noticed that when building a System DSN (Administrative Tools > Data Sources), the creation and test would succeed and the user name would save, but the password would not. As such, the DSN would never work properly. Creating a User DSN however would store the password correctly. This seems to be different than in both XP and Vista (or at least XP) and we wanted to know if anyone knew the reason why. Thanks.