• Topic
  • Discussion

    • doc.FAQ.WhatAreTheDifferencesAmongUserSystemAndFileDSNs





    • User DSN - User DSNs are available for use only to the user who created it. User DSN connection parameters are stored in the HKEY CURRENT_USER\Software\ODBC\ODBC.INI section of the registry.
    • System DSN - System DSNs are available for use to any user who logs onto the local system. System DSN connection parameters are stored in the HKEY LOCAL_MACHINE\Software\ODBC\ODBC.INI section of the registry.
    • File DSN - File DSNs comprise a set of DSN connection parameters that are saved to a text file with a .DSN extension. File DSNs typically appear in C:\Program Files\Common Files\ODBC\Data OpenLink recommends use of System DSNs whenever possible.