Method
ODBCDatabase.DataSourceNames
Warning
This item was deprecated in version 2020r2. Please use ODBCDatabase.DataSources as a replacement.
Description
Returns a RowSet with a list of configured Data Source Names (DSN). Returns both User and System DSNs in a single RowSet.
Notes
The instance of the ODBCDatabase does not have to be connected to a database in order to use this method.
The RowSet returned by DataSourceNames has two columns. They are:
Name: The data source name
Description: The Name of the ODBC driver.
References
Sample code
This code gets all the ODBC data source names and adds them to a ListBox:
DataSourceList.DeleteAllRows
Dim db As New ODBCDatabase
Dim rs As RecordSet
rs = db.DataSourceNames
If rs <> Nil Then
While Not rs.EOF
DataSourceList.AddRow(rs.Field("Name").StringValue, rs.Field("Description").StringValue)
rs.MoveNext
Wend
rs.Close
End If
Compatibility
All project types on all supported operating systems.