What is data source name (DSN)? - Definition from WhatIs.com


data source name (DSN)

Part of the Database glossary:

(DSN also stands for Deep Space Network .)

A data source name (DSN) is a data structure that contains the information about a specific database that an Open Database Connectivity ( ODBC ) driver needs in order to connect to it. Included in the DSN, which resides either in the registry or as a separate text file, is information such as the name, directory and driver of the database, and, depending on the type of DSN, the ID and password of the user. The developer creates a separate DSN for each database. To connect to a particular database, the developer specifies its DSN within a program. In contrast, DSN-less connections require that all the necessary information be specified within the program.

There are three kinds of DSN: user DSNs (sometimes called machine DSN s); system DSN s; and file DSN s. User and system DSNs are specific to a particular computer, and store DSN information in the registry. A user DSN allows database access for a single user on a single computer, and a system DSN for any user of a particular computer. A file DSN contains the relevant information within a text file with a .DSN file extension, and can be shared by users of different computers who have the same drivers installed.

This was last updated in March 2011
Contributor(s): Beth Kane
Posted by: Margaret Rouse

Related Terms


  • structured data

    - Structured data contrasts with unstructured and semi-structured data. The three can be considered to exist on a continuum, with unstructured data being the least formatted and structured data being... (WhatIs.com)


    - SAP S/4HANA is the next generation of the Business Suite ERP platform, built on the SAP HANA in-memory platform. S/4HANA aims to be easier to use and administer to allow enterprises to solve more c... (SearchSAP.com)

  • MPP database (massively parallel processing database)

    - An MPP database is a database that is optimized to be processed in parallel for many operations to be performed by many processing units at a time. (SearchDataManagement.com)


  • Database

    - Terms related to databases, including definitions about relational databases and words and phrases about database management.

  • Internet applications

    - This WhatIs.com glossary contains terms related to Internet applications, including definitions about Software as a Service (SaaS) delivery models and words and phrases about web sites, e-commerce ...

Ask a Question. Find an Answer.Powered by ITKnowledgeExchange.com

Ask An IT Question

Get answers from your peers on your most technical challenges

Ask Question

Tech TalkComment



    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.