ODBCDatabase.DataSourceNames

Method

ODBCDatabase.DataSourceNames() As RecordSet

Supported for all project types and targets.

Returns a RecordSet with a list of configured Data Source Names (DSN). Returns both User and System DSNs in a single RecordSet.

Notes

The instance of the ODBCDatabase does not have to be connected to a database in order to use this method.

The RecordSet returned by DataSourceNames has two columns. They are:

Name: The data source name
Description: The Name of the ODBC driver.

References

SQLDataSources ODBC function

Example

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