Use this policy to restrict the use of program generated data sources when using iSeries Access ODBC support.
A "program generated data source" is one that is created temporarily when an ODBC connection is made without using the DSN option to specify the name of the data source. Note that use of the FILEDSN option does not mean the data source used is named. FILEDSN simply specifies the name of a file containing connection options, not the name of a data source.
If a program first creates a data source (using SQLCreateDataSource, for example) and then connects using the DSN option, the data source is not considered a program generated data source, but a named data source. To restrict the use of named data sources, use the Prevent use of named data sources policy.
This policy is an override of machine setting enabled.
| Policy Type | ||
|---|---|---|
| Restriction | Configuration | |
| Suggestion | Mandate | |
| X | ||
| Policy Scope | |||
|---|---|---|---|
| Per PC (all users) | Per user | Per user setting (May override machine setting) | Per iSeries connection |
| X | X | X | |
Related concepts
ODBC policy: Prevent use of named data sources