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.

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.