DataSourceOdbc

Overview

DataSourceOdbc is a specialized DataSource for importing data from an ODBC database.
To create a new DataSource use TFORMer Designer.

The main properties to characterize a DataSourceOdbc are:

• The DSN
  The DSN represents the name of the database connection as defined in the Microsoft Windows Control Panel. Please keep in mind that the DSN is a part of the connection string and thus a complete specification is required.

• The user name
  It depends on the database connection if the user-name is required or not.

• The password
  It depends on the database connection if the password is required or not.

• The SQL SELECT statement
  The column names returned by the SQL SELECT statement should match the names of the DataFields in the FormLayout. Use SQL aliases if required.