Data Source Name - Types of Data Source Name

Types of Data Source Name

Two kinds of DSN exist:

  • Machine DSNs - stored in collective configuration files (e.g., /etc/odbc.ini, ~/.odbc.ini) and/or system resources (e.g., Windows Registry HKLM\Software\ODBC\odbc.ini)
  • File DSNs - stored in the filesystem with one DSN per file

These are further broken down into

  • System DSNs - accessible by any and all processes and users of the system, stored in a centralized location (e.g., /etc/odbc.ini, /etc/odbc_file_dsns/)
  • User DSNs - accessible only by the user who created the DSN, stored in a user-specific location (e.g., ~/.odbc.ini, ~/odbc_file_dsns/)

Read more about this topic:  Data Source Name

Famous quotes containing the words types of, types, data and/or source:

    “... there are two types of happiness and I have chosen that of the murderers. For I am happy. There was a time when I thought I had reached the limit of distress. Beyond that limit, there is a sterile and magnificent happiness.”
    —Albert Camus (1913–1960)

    “The bourgeoisie loves so-called “positive” types and novels with happy endings since they lull one into thinking that it is fine to simultaneously acquire capital and maintain one’s innocence, to be a beast and still be happy.”
    —Anton Pavlovich Chekhov (1860–1904)

    “To write it, it took three months; to conceive it three minutes; to collect the data in it—all my life.”
    —F. Scott Fitzgerald (1896–1940)

    “Might not the beatific vision become a source of boredom, in the long run?”
    —Samuel Beckett (1906–1989)