version 6.0 (Modified)
OC GET DSN LIST (cursor_ID; dsn_Array; desc_Array)
| Parameter | Type | Description | |
| cursor_ID | Longint | Cursor ID | |
| dsn_Array | String | Name of 4D array | |
| desc_Array | String | Name of 4D array |
Description
The OC GET DSN LIST command enables you to query what ODBC data sources are available on the client machine.
cursor_ID must be the ID of a previously created and inactive cursor.
Note: cursor_ID is not mandatory for this command because you do not need to be connected. You can pass 0 for this parameter and the command will still work fine. However, for compatibility with existing applications, we retain the cursor_ID parameter in the command.
dsn_Array is the name of a string array that will accept the values of the list of available data sources.
desc_Array is the name of a string array that will accept the values of the list of descriptions for the available data sources.
Example
The following statement loads the lists of available data sources and their descriptions into arrays.
ARRAY STRING(30;arDSN;0) ARRAY STRING(30;arDescrip;0) OC GET DSN LIST(cursor_id;"arDSN";"arDescrip")