The DATA_SOURCE_NAMES
view contains one entry per configured DSN and includes the following:
-
This view contains a default BASE
DSN.
-
This view also contains an entry
for the ADMIN DSN which is a DSN generated by the system to be used
with server administration DDL and system catalog queries. The value
of the DATA_SERVICE_NAME column is _SERVER_.
-
If SQL Logging
is enabled, this view also shows the SQL_LOG
DSN.
The table below lists
the columns that are associated with the DATA_SOURCE_NAMES view:
|
|
|
|
|
|
|
Specifies the unique
name of the DSN.
|
|
|
|
Specifies the unique
name of the data service.
|
|
|
|
Specifies the descriptive
text.
|
|
|
|
Specifies the format
of the content as STANDARD, which is the standard driver connection
string.
|
|
|
|
Specifies the name of
the user that owns the DSN.
|
|
|
|
Specifies the ID of
the user that owns the DSN.
|
|
|
|
Specifies the owner
type as U (User) or R (Role).
|
|
|
|
Specifies the DSN type
as one of the following:
|