User DSN vs. System DSN

Article translations Article translations
Article ID: 966915 - View products that this article applies to.
Expand all | Collapse all


When setting up an ODBC Data Source you have the option to set up by User DSN or System DSN. A User DSN is specific to a user on the workstation. For example, if you log on to a machine as user "John," set up a User DSN, then log off, and then log on to the machine as user "Sally", "Sally" will not see the Data Source. Why? It's specific to John's profile, not Sally's. Conversely, if you set up a System DSN, it does not matter who logs on to the machine; all users that logon to that workstation will have access to that Data Source. FRx Software recommends using a System DSN for all FRx data sources.


Article ID: 966915 - Last Review: January 27, 2009 - Revision: 1.0
  • Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
  • FRx Financial Reporter 6.5

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from