Name

sql_data_sources — get list of available DSNs

Synopsis

sql_data_sources ( );

Description

sql_data_sources is used to get the list of datasources available to the dsn. It returns a vector of 2 element vectors containing Data source name and type pairs.

Parameters

As defined in ODBC API for the corresponding catalog call.

Return Types

As defined in ODBC API for the corresponding catalog call.

A vector containing a 2 element vector for each defined data source with a string data source name as 1st element and a string data source type as the 2nd element.

Examples

Example24.394.Simple Use

SQL> select aref (aref (sql_data_sources(), 0), 0);
callret
VARCHAR
_______________________________________________________________________________

Local Virtuoso

1 Rows. -- 4 msec.