|
 Home
FAQs
News
Request Form
Post Resume
Web Request
Job World
Comments
Quote of the
day:
If someone betrays you once, it is his
fault;
If he betrays you twice, it is your fault.
|
What is DSN?
DSN is Data Source Name. There are three types of DSN,
- User DSN,
- System DSN and
- File DSN.
User DSN
The User DSN is a data source that is user specific. A User DSN is stored
locally but is available only to the user who creates it. User DSNs are
not used by Microsoft Query 97. If you use Microsoft Jet, ODBC, or
Structured Query Language (SQL) commands and bypass Microsoft Query, User
DSNs are required. User DSNs are stored in the Windows registry under the
following key:
HKEY_CURRENT_USER\Software\Odbc\Odbc.ini\Odbc Data sources
System DSN
Unlike a User DSN, a System DSN is not user specific. A System DSN is
stored locally and is not dedicated to a particular user. Any user who
logs on to a computer that has permission to access the data source can
use a System DSN. Some programs, such as Microsoft SQL Server or Microsoft
Internet Information Server (IIS), require a System DSN. This DSN must be
created on the server where the program is located. System DSNs are stored
in the Windows registry under the following key:
HKEY_LOCAL_MACHINE\Software\Odbc\Odbc.ini\Odbc Data sources
File DSN
The File DSN is created locally and may be shared with other users. The
File DSN is file based, which means that the .dsn file contains all the
information required to connect to the data source. Note that you must
install the ODBC driver locally to use a File DSN. Microsoft Query uses
File DSNs but Microsoft Jet and ODBC do not use File DSNs.
The File DSNs are stored by default in the Program Files\Common Files\Odbc\Data
Sources folder. File DSNs are not stored in the Windows registry. The .dsn
file is a text file that you can view in any text editor, such as
Microsoft Notepad.
NOTE: When you connect to an existing data source using Microsoft Query,
only the available File DSNs that are stored on that computer are
displayed. Microsoft Query does not display User or System DSNs. However,
you can create a File DSN that points to a System DSN.
Back to Top
|
