skip to main content
Connection property descriptions : DescribeInputParameters
  

Try DataDirect Drivers Now

DescribeInputParameters

Purpose

Determines whether the driver attempts to determine, at execute time, which data type to use to send input parameters to the database server. Sending parameters as the data type the database expects improves performance and prevents locking issues caused by data type mismatches.

Valid values

noDescribe | describeIfString | describeIfDateTime | describeAll

Behavior

If set to noDescribe, the driver does not attempt to describe input parameters and sends String and Date/Time/Timestamp input parameters to the server as specified by the StringInputParameterType and DateTimeInputParameterType properties.
If set to describeIfString, the driver submits a request to the database to describe String input parameters. The driver uses the data types that are returned by the driver to determine whether to describe the String input parameters as nvarchar or varchar. If this operation fails, the driver sends String input parameters to the server as specified by the StringInputParameterType property.
If set to describeIfDateTime, the driver submits a request to the database to describe Date/Time/Timestamp input parameters. The driver uses the data types that are returned by the driver to determine how to describe the Date/Time/Timestamp input parameters. If this operation fails, the driver sends Date/Time/Timestamp input parameters to the server as specified by the DateTimeInputParameterType property.
If set to describeAll, the driver submits a request to the database to describe both String and Date/Time/Timestamp input parameters and uses the data types that are returned by the driver to determine which data type to use to describe the input parameters. If this operation fails, the driver sends String input parameters to the server as specified by the StringInputParameterType property and sends Date/Time/Timestamp input parameters to the server as specified by the DateTimeInputParameterType property.

Data source method

setDescribeInputParameters

Default

noDescribe

Data type

String

See also

Data type handling properties