Content deleted Content added
Saku.arowena (talk | contribs) Added image to page Tag: Mobile edit |
m Reverted edits by Saku.arowena (talk) to last revision by Cljeffery (HG) |
||
Line 1:
{{Unreferenced|date=January 2009}}
In [[computing]], a '''data source name''' ('''DSN''', sometimes known as a '''database source name''', though data sources are not limited to [[database management system|databases]]) is a string that has an associated [[data structure]] used to describe a connection to a [[Datasource|data source]]. Most commonly used in reference to [[ODBC]], DSNs may also be defined for [[JDBC]] and other data access mechanisms.
Line 25 ⟶ 14:
Standardizing DSNs offers a level of [[indirection]] that various applications (for example: [[Apache HTTP Server|Apache]]/[[PHP]] and [[Internet Information Services|IIS]]/[[Active Server Pages|ASP]]) can take advantage of in accessing shared data sources.
== Types of data source name ==
Two kinds of DSN exist:
* '''Machine DSNs''' - stored in collective configuration files (e.g., /etc/odbc.ini, ~/.odbc.ini) and/or system resources (e.g., Windows Registry HKLM\Software\ODBC\odbc.ini)
* '''File DSNs''' - stored in the filesystem with one DSN per file
These are further broken down into
* '''System DSNs''' - accessible by any and all processes and users of the system, stored in a centralized ___location (e.g., /etc/odbc.ini, /etc/odbc_file_dsns/<filename>)
* '''User DSNs''' - accessible only by the user who created the DSN, stored in a user-specific ___location (e.g., ~/.odbc.ini, ~/odbc_file_dsns/<filename>)
==Misuse of the term==
|