Purpose

Determines whether the driver attempts to determine, at execute time, which data type to use to send output 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 output parameters and sends String and Date/Time/Timestamp output parameters to the server as specified by the StringOutputParameterType and DateTimeOutputParameterType properties.

If set to describeIfString, the driver submits a request to the database to describe String output parameters. The driver uses the data types that are returned by the driver to determine whether to describe the String output parameters as NVARCHAR or VARCHAR. If this operation fails, the driver sends String output parameters to the server as specified by the StringOutputParameterType property.

If set to describeIfDateTime, the driver submits a request to the database to describe Date/Time/Timestamp output parameters. The driver uses the data types that are returned by the driver to determine how to describe the Date/Time/Timestamp output parameters. If this operation fails, the driver sends Date/Time/Timestamp output parameters to the server as specified by the DateTimeOutputParameterType property.

If set to describeAll, the driver submits a request to the database to describe both String and Date/Time/Timestamp output parameters and uses the data types that are returned by the driver to determine which data type to use to describe the output parameters. If this operation fails, the driver sends String output parameters to the server as specified by the StringOutputParameterType property and sends Date/Time/Timestamp output parameters to the server as specified by the DateTimeOutputParameterType property.

Default

noDescribe

Data Type

String