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

         .-USER---.                      
>>-LIST--+--------+--ODBC DATA SOURCES-------------------------><
         '-SYSTEM-'                      

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

               User ODBC Data Sources

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