Editing Data source name (section)

== Example of use ==
Software (e.g., Crystal Reports, Microsoft Excel, PHP, Perl, Python, Ruby) users can submit CRUD (Create, Read, Update, Delete) queries to a data source by establishing a connection to the DSN.

ASP ([[VBScript]]) code to open a DSN connection might look like the following:

<syntaxhighlight lang="vbscript">
Dim DatabaseObject1
Set DatabaseObject1 = Server.CreateObject("ADODB.Connection")
DatabaseObject1.Open("DSN=example;")
</syntaxhighlight>

In [[PHP]] using the [https://pear.php.net/package/DB/ PEAR::DB] package to open a connection without an external DSN (a "DSN-less connection", i.e., using a Connection String){{Clarify|How is this an example of DSN use|date=June 2013}}, the code might resemble the following:

<syntaxhighlight lang="php">
require_once("DB.php");
//$dsn = "<driver>://<username>:<password>@<host>:<port>/<database>";
$dsn = "mysql://john:pass@localhost:3306/my_db";
$db = DB::connect($dsn);
</syntaxhighlight>

PHP with PDO:<ref>{{cite web |title=PHP: PDO - Manual |url=https://www.php.net/pdo |website=www.php.net |access-date=22 January 2025 |language=en}}</ref>
<syntaxhighlight lang="php">
$dsn = "mysql:host=localhost;dbname=example";
$dbh = new PDO($dsn, $username, $password);
</syntaxhighlight>

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.

<syntaxhighlight lang="perl">
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($dsn,'username','password');
</syntaxhighlight>