What is a DSN and how can I use a DSN or a DSN-less connection to connect to a database?

DSN is an abbreviation for Data Source Name. Data Source Name is a parameter that stores Data Source information (which includes the source of data such as relational database, and the connectivity information for accessing the data). The primary purpose of the DSN is to provide connectivity to a database through an ODBC driver.