Full text search
function	SQLDataSources

Library: ODBC Include: omodbc.xin

Returns: Numeric An SQL return code. The following values may be returned: SQL_SUCCESS (the information was retrieved). SQL_SUCCESS_WITH_INFO (the information was retrieved, but a message was issued). SQL_ERROR (an error occurred). SQL_INVALID_HANDLE (the handle is invalid). SQL_NO_DATA (no data was found).

Declaration

  define external counter function SQLDataSources
     (  read-only SQL_handle_type EnvironmentHandle,
        value counter Direction,
        modifiable stream ServerName,
        value counter BufferLength1,
        modifiable counter NameLength1,
        modifiable stream Description,
        value counter BufferLength2,
        modifiable counter NameLength2 )

Returns information about a data source.

Input arguments:

1. EnvironmentHandle.
2. Direction. Determines the data source whose information is being requested. The following values are allowed:
   • SQL_FETCH_NEXT
   • SQL_FETCH_FIRST
   • SQL_FETCH_FIRST_USER
   • SQL_FETCH_FIRST_SYSTEM
3. BufferLength1. The maximum allowable length of ServerName.
4. BufferLength2. The maximum allowable length of Description.

Output arguments:

• ServerName. The returned data source name.
• NameLength1. The returned length of ServerName.
• Description. The returned description of the driver associated with the data source.
• NameLength2. The returned length of Description.