Data source name


In computing, a data source name 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.
DSN attributes may include, but are not limited to:
  • the name of the data source
  • the location of the data source
  • the name of a database driver which can access the data source
  • a user ID for data access
  • a user password for data access
The system administrator of a client machine generally creates a separate DSN for each relevant data source.
Standardizing DSNs offers a level of indirection; various applications can take advantage of this in accessing shared data sources.

Types of data source name

Two kinds of DSN exist:
These are further broken down into
  • System DSNs – accessible by any and all processes and users of the system, stored in a centralized location
  • User DSNs – accessible only by the user who created the DSN, stored in a user-specific location

    Example of use

Software users can submit CRUD queries to a data source by establishing a connection to the DSN.
ASP code to open a DSN connection might look like the following:

Dim DatabaseObject1
Set DatabaseObject1 = Server.CreateObject
DatabaseObject1.Open

In PHP using the package to open a connection without an external DSN, the code might resemble the following:

require_once;
//$dsn = "://:@:/";
$dsn = "mysql://john:pass@localhost:3306/my_db";
$db = DB::connect;

PHP with PDO:

$dsn = "mysql:host=localhost;dbname=example";
$dbh = new PDO;

In Perl, using the Perl DBI module, each driver has its own syntax for the DSN attributes. The only requirement that DBI makes is that all the information, except for username and password is supplied in a single string argument.

my $dsn = "DBI:Pg:database=finance;host=db.example.com;port=$port";
$dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";
$dsn = "DBI:Oracle:host=$host;sid=$sid;port=$port";
$dsn = "DBI:SQLite:dbname=$dbfilename";
my $dbh = DBI->connect;