%META:TOPICPARENT{name="InstallConfigODBC"}%

= What are the differences between User DSNs and System DSNs? What about Machine DSNs and File DSNs? =

%TOC%

== User vs System ==

User and System DSNs are so named because of their accessibility.  System DSNs are recommended for most purposes.  

User and System DSNs may each be either File or Machine DSNs.

**User DSN** - A User DSN is only available for use by the user who created it.

**System DSN** - A System DSN is available for use by any user. 

== Machine vs File ==

Machine and File DSNs are so named because of their storage locations and management methods.  Machine DSNs are recommended for most purposes.  

File and Machine DSNs may each be either User or System DSNs.

**Machine DSN** - A Machine DSN is saved to a repository file (or files) determined by the environment's ODBC driver manager.

**File DSN** - A File DSN is a set of DSN connection attributes that is saved to a standalone text file named by the DSN with a {{{.DSN}}} extension (e.g., for a DSN "{{{my_dsn}}}", the filename would typically be "{{{my_dsn.dsn}}})". 


== Typical Storage Locations ==

<b>Note:</b> The following locations are defaults, but are not the only places that these DSNs or files may be found.

=== Mac OS X ===

|               |   <b>Machine DSNs</b>   |   <b>File DSNs</b>   |
|   <b>System DSNs</b>   | <code><nowiki>/Library/ODBC/odbc.ini</nowiki></code> %BR%%BR% <code><nowiki>$ODBCINI</nowiki></code> %BR%%BR% <code><nowiki>/etc/odbc.ini</nowiki></code>  | <code><nowiki>/Library/ODBC/ODBCDataSources/</nowiki></code>  |
|   <b>User DSNs</b>   | <code><nowiki>/Users/*/Library/ODBC/odbc.ini</nowiki></code> %BR%%BR% <code><nowiki>/Users/*/.odbc.ini</nowiki></code>          | <code><nowiki>/Users/*/Library/ODBC/ODBCDataSources/</nowiki></code>  |


=== Unix-like OS (AIX, HP-UX, Linux, Solaris, etc.) ===

|               |   <b>Machine DSNs</b>   |   <b>File DSNs</b>   |
|   <b>System DSNs</b>   | <code><nowiki>$ODBCINI</nowiki></code> %BR%%BR% <code><nowiki>/etc/odbc.ini</nowiki></code>  |   |
|   <b>User DSNs</b>   | <code><nowiki>~/.odbc.ini</nowiki></code>          |   |


=== Windows ===

|               |   <b>Machine DSNs</b>   |   <b>File DSNs</b>   |
|   <b>System DSNs</b>   | <code><nowiki>HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI</nowiki></code>   | <code><nowiki>C:\Program Files\Common Files\ODBC\Data Sources\</nowiki></code>   |
|   <b>User DSNs</b>   | <code><nowiki>HKEY_CURRENT_USER\Software\ODBC\ODBC.INI</nowiki></code>           |   |