DataSourceOdbc

Overview

DataSourceOdbc is a specialized DataSource for importing data from an ODBC database. This class is used to manipulate existing DataSourceOdbc objects. 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.