The File DSNs are stored by default in the following location:Program Files\Common Files\Odbc\Data Sources folder. dsn file is a text file that you can view in any text editor, such as Microsoft Notepad. The ODBC driver must be installed locally. To use a File DSN, it must contain the information required to connect to the desired data source. DSN extension (not in the Windows registry). File DSN: This is a DSN that is stored in a text file with a. Like the System DSN, the information is stored in the Windows registry under the following key: HKEY_CURRENT_USER\Software\Odbc\Odbc.ini\Odbc Data sourcesģ. Only the user who created the DSN can see this and use it. User DSN: This is a DSN created for a specific user. The System DSN are stored in the Windows registry under the following key: HKEY_LOCAL_MACHINE\Software\Odbc\Odbc.ini\Odbc Data sourcesĢ. This DSN must be created on the machine where the program is located. System DSN: This is the DSN used throughout the system, any with proper rights may log in. Here are the various types of ODBC Data Source Types:ġ. It stores the connection details like database name, directory, database driver, UserID, password, etc. In other words, it is a symbolic name that represents the ODBC connection. It is the name that applications use to request a connection to an ODBC Data Source. What is a DSN (Data Source Name)? More Information
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |