The ODBC Connection can be configured with global settings as well as with DID as with DID Module specific settings. The ResetConnectionsAfterModel setting can only be used on DID level. The following listing describes the available settings.
The following settings are available:
Setting |
Default |
Description |
ConnStr |
Empty. A DSN has to be specified in this setting or the DSN setting has to be set. |
A standard ODBC connection string. It must at least contain a setting for the data source name to be used, like in "DSN=MyDsn". Other settings are ODBC driver specific and can be found in the appropriate documentation for the specific ODBC driver. |
CacheStats |
Y |
The ITP ODBC Connection caches SQL statements intelligently for performance reasons. |
DisconnectAfterModel |
N |
Normally the connection to the data source will stay open until the DataManager is stopped. If you set DisconnectAfterModel to Y, ITP closes the connection to the data source after every model. |
ResetConnectionsAfterModel |
N |
If you set ResetConnectionsAfterModel, the DataManager will not be stopped but ITP will completely rebuilt the connection for each model thus allowing you to change for example the Userid, Password setting for the next model. This setting can only be used on DID level. |
UserId |
Empty |
The userid for the database login. |
Password |
Empty |
The password for the database login. |
DSN |
Empty. Either this setting must be set or a DSN must be specified in the Connstr setting. |
The ODBC Data Source Name that is used. |
The values specified in Connstr, UserID, Password and DSN will be combined into one connection string