Data Source Name
DSN (Data Source Name) is a file which stores a database name. An ODBC driver uses a DSN file and reads a database name then connects with that database.
Tpyes of DSN
- System DSN
- User DSN
- File DSN
System DSN: System DSN will be stored in a shareable location of registry and this type of DSN is accessible for multiple user accounts of the system.
User DSN: User DSN will be stored in a non-shareable location of registry and this type of DSN is only accessible for one user account of the system.
File DSN: File DSN is like user DSN, but the DSN will be stored in a user given location of hard disk.