ODBC - DSN (data source name)

1 - About

When an ODBC based application connects to a database, it connects to a logical name, the Data Source Name (DSN), which identifies the datasource to which it wants to connect.

Some external repository of configuration information holds the various DSN values that are available, together with the necessary configuration and control information needed by the ODBC driver to establish a connection and manage usage of the data source.

The DSN (data source name) is a data structure that contains the information about a specific data source (database, …), typically used by an ODBC driver to be able to connect to it.

The DSN contains information about the data source such as:

  • the name,
  • the directory,
  • and the driver.

On Windows, the DSN also specifies the ODBC driver to be used to access the database.

3 - Type

3.1 - System

3.2 - User

4 - Configuration

To configure a DSN:

5 - Characteristics

A DSN has the following characteristics:

  • Its maximum length is 32 characters.
  • It is composed of ASCII characters except for the following: [ ] { } , ; ? * = ! @ \
  • It cannot contain spaces.
odbc/dsn.txt · Last modified: 2018/02/13 11:26 by 172.68.174.26