To prevent possible compatibility issues from occurring, the connection attribute EnableTdIntervals has been added. This attribute will allow applications to enable/disable the mapping of interval types to the Provider Specific interval types.
Compatibility issues will occur when an older application has set the DataAdapter.ReturnProviderSpecificTypes property to true and expects the corresponding .Net System types to be used in the columns of the resulting DataTable. If .Net System types are expected, EnableTdIntervals must be set to false. An example of a connection string to support this option is as follows:
Data Source = Teradata1; User ID = MyUser; Password = MyPass; Enable TdTdIntervals = false;
Refer to Enabling Provider Specific Types for further information.