Browse Definitions :
Definition

data source name (DSN)

What is a data source name (DSN)?

A data source name (DSN) is a data structure containing information about a specific database to which an Open Database Connectivity (ODBC) driver needs to connect. (Note: DSN also stands for Deep Space Network.)

The DSN, which resides either in the registry or as a separate text file, contains information such as the database name, directory and driver. Depending on the type of DSN, it can also contain information like the ID and password of the user.

A developer creates a separate DSN for each database and specifies its DSN within a program to connect to a particular database. In contrast, DSN-less connections require that all the necessary information be defined within the program.

flowchart of open database connectivity (ODBC)
A data source name contains data about a specific database to which an Open Database Connectivity driver needs to connect.

What are the different types of data source names (DSNs)?

There are three types of data source names:

  1. File DSN. This is stored in the filesystem using one DSN for each file. Users who have installed the same ODBC drivers can share these files.
  2. System DSN. This DSN is accessible by all system processes and users and is stored in a centralized location.
  3. User DSN. This is stored in a user-specific location and is accessible only by the user who created the DSN. Sometimes called machine DSN, it is built on the device where the program is located and stored in collective configuration files or system resources.

The user DNS and system DSN are specific to a particular computer and store DSN data 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. Users of different computers with the same drivers installed can share this file.

What is the data source name in Oracle?

In an Oracle database, an ODBC DSN stores the data required to connect to a database hosted on a remote database server. A DSN system enables access to multiple users, not just the user who created it.

What is the data source name file in QuickBooks?

In the enterprise accounting software QuickBooks, DSN is a text file that contains information required for the QuickBooks program to access QuickBooks company files.

See also: Java Database Connectivity driver, data management, database management system, relational database management system, object-oriented database management system, managing databases in a hybrid cloud, open source vs. proprietary database management

This was last updated in December 2022

Continue Reading About data source name (DSN)

Networking
  • firewall as a service (FWaaS)

    Firewall as a service (FWaaS), also known as a cloud firewall, is a service that provides cloud-based network traffic analysis ...

  • private 5G

    Private 5G is a wireless network technology that delivers 5G cellular connectivity for private network use cases.

  • NFVi (network functions virtualization infrastructure)

    NFVi (network functions virtualization infrastructure) encompasses all of the networking hardware and software needed to support ...

Security
  • virus (computer virus)

    A computer virus is a type of malware that attaches itself to a program or file. A virus can replicate and spread across an ...

  • Certified Information Security Manager (CISM)

    Certified Information Security Manager (CISM) is an advanced certification that indicates that an individual possesses the ...

  • cryptography

    Cryptography is a method of protecting information and communications using codes, so that only those for whom the information is...

CIO
  • B2B (business to business)

    B2B (business-to-business) is a type of commerce involving the exchange of products, services or information between businesses, ...

  • return on investment (ROI)

    Return on investment (ROI) is a crucial financial metric investors and businesses use to evaluate an investment's efficiency or ...

  • big data as a service (BDaaS)

    Big data as a service (BDaS) is the delivery of data platforms and tools by a cloud provider to help organizations process, ...

HRSoftware
  • talent acquisition

    Talent acquisition is the strategic process an organization uses to identify, recruit and hire the people it needs to achieve its...

  • human capital management (HCM)

    Human capital management (HCM) is a comprehensive set of practices and tools used for recruiting, managing and developing ...

  • Betterworks

    Betterworks is performance management software that helps workforces and organizations to improve manager effectiveness and ...

Customer Experience
  • martech (marketing technology)

    Martech (marketing technology) refers to the integration of software tools, platforms, and applications designed to streamline ...

  • transactional marketing

    Transactional marketing is a business strategy that focuses on single, point-of-sale transactions.

  • customer profiling

    Customer profiling is the detailed and systematic process of constructing a clear portrait of a company's ideal customer by ...

Close