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 or Project.AddDataSource.
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.
Modifying an Existing ODBC DataSource
Sample source code for modifying an existing ODBC-DataSource:
Project project = repository.GlobalProject;
DataSourceOdbc dataSource = (DataSourceOdbc) (project.GetDataSource("ODBC"));
dataSource.User = "";
dataSource.Password = "";