LIST ODBC DATA SOURCES command

The LIST ODBC DATA SOURCES command lists all available user or system ODBC data sources.

A data source, in ODBC (Open Database Connectivity) terminology, is a user-defined name for a specific database. That name is used to access the database or file system through ODBC APIs. On Windows, either user or system data sources can be cataloged. A user data source is only visible to the user who cataloged it, whereas a system data source is visible to and can be used by all other users.

This command is available on Windows only.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagramLISTUSERSYSTEMODBC DATA SOURCES

Command parameters

USER
List only user ODBC data sources. This is the default if no keyword is specified.
SYSTEM
List only system ODBC data sources.

Examples

The following example is sample output from the LIST ODBC DATA SOURCES command: 
               User ODBC Data Sources

Data source name                 Description
-------------------------------- ----------------------------------------
SAMPLE                           IBM DB2 ODBC DRIVER