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 Http Cookie

Http Cookie

In Internet technologies, a cookie is a text file that a Web server saves on a client machine during a Hypertext Transfer Protocol (HTTP) session. HTTP Cookies are used to record information about the client’s usage patterns, including the date and time the client visited the site, which pages were accessed, Web browser preferences, and so on.