Data source name: Difference between revisions

Revision as of 10:00, 22 March 2022

Revision as of 16:33, 13 April 2022

Line 1:

{{Short description|String that has an associated data structure used to describe a connection to a data source}}

{{UnreferencedMore citations needed|date=JanuaryApril 20092022}}

[[Internet|In]] [[computing]], a '''data source name''' ('''DSN''', sometimes known as a '''database source name''', though "[[Computer file|data sources]]" can comprise other repositories apart from [[database management system|databases]]) is a string that has an associated [[data structure]] used to describe a connection to a data source. Most commonly used in connection with [[ODBC]], DSNs also exist for [[JDBC]] and for other data access mechanisms. The term often overlaps with "[[connection string]]". Most systems do not make a distinction between DSNs or connection strings and the term can often be used interchangeably.<ref>[https://www.gridgain.com/docs/latest/developers-guide/SQL/ODBC/connection-string-dsn Connection String and DSN]</ref>

Line 9:

* the ___location of the data source

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

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

* a user password for data access (if required)

Line 44:

$dsn = "mysql://john:pass@localhost:3306/my_db";

$db = DB::connect($dsn);

</syntaxhighlight>{{ClarifymeClarify|How is this an example of DSN use|date=June 2013}}

PHP with PDO.

Line 76:

[[Category:Data access technologies| ]]

{{database-stub}}