Data Source Name (DSN)


Definition of Data Source Nama in the Network Encyclopedia.

What is Data Source name (DSN)?

DSN stands for Data Source Name, is a unique name used to create a data connection to a database using open database connectivity (ODBC). The data source name (DSN) is used by applications that need to access or manage data in the database.



All ODBC connections require that a DSN be configured to support the connection. When a client application wants to access an ODBC-compliant database, it references the database using the DSN.

Data Source name (DSN)
Data Source Name (DSN)




You can configure a DSN for an ODBC-compliant database using the Microsoft Windows NT ODBC or the Windows 2000 Administrative Tools\Data Sources (ODBC) utility in Control Panel. You can create three kinds of DSNs:

  • A user DSN, which is visible only to the user who creates it and can be used only on the current machine.
  • A system DSN, which is visible to all users on the machine and is also accessible to Windows NT and Windows 2000 services. A system DSN is stored in the registry.
  • A file DSN, which can be shared by users who have the same ODBC drivers installed. A file DSN is stored in a file.

Examples of Data Source Name usage

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

Dim DatabaseObject1
Set DatabaseObject1 = Server.CreateObject("ADODB.Connection")
DatabaseObject1.Open("DSN=example;")

In PHP using the PEAR::DB package to open a connection without an external DSN (a “DSN-less connection”, i.e., using a Connection String), the code might resemble the following

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

TIP

When you design Web applications that use Microsoft ActiveX Data Objects (ADO) for accessing database information, be sure to use either a file DSN or a system DSN because ADO does not work with user DSNs.



Editor

Articles posted after being checked by editors.

Recent Content

link to Power-on Self Test (POST)

Power-on Self Test (POST)

Power-On Self Test is a special set of ROM routines that run whenever a PC is booted. The power-on self test (POST) is designed to test whether system components are functioning properly before attempting to boot the operating system, and checks such things as the RAM, keyboard, and disk drives.