Data source name: Difference between revisions

Revision as of 11:09, 27 April 2014

Revision as of 00:41, 5 September 2014

Line 1:

{{Unreferenced|date=January 2009}}

In [[computing]], a '''data source name''' ('''DSN''', sometimes known as a '''database source name''', though "[[data sourcessource]]s" arecan notcomprise limitedother torepositories apart from [[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 referenceconnection towith [[ODBC]], DSNs may also be definedexist for [[JDBC]] and for other data access mechanisms.

DSN attributes may include, but are not limited to:

* name of the data source

* ___location of the data source

* name of a driver which can access the data source

* user ID for data access (if required)

* user password for data access (if required)

* the name of the data source

The system administrator of a client machine creates a separate DSN for each relevant data source.

* the ___location of the data source

* the name of a [[database driver]] which can access the data source

* a [[User identifier | user passwordID]] for data access (if required)

* a user IDpassword for data access (if required)

The system administrator of a client machine generally creates a separate DSN for each relevant data source.

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.

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 this in accessing shared data sources.

== Types of data source name ==