| title | Setting ExtendedAnsiSQL | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 01/19/2017 | |
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.reviewer | ||
| ms.technology | connectivity | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | 37b775d1-65ac-45ac-8572-454bc4e3c1a2 | |
| author | David-Engel | |
| ms.author | v-daenge |
The attribute can be controlled in the connection string by adding the ExtendedAnsiSQL attribute:
| Value | Description |
|---|---|
| ExtendedAnsiSQL=0 (default) | This setting does not enable the new features. |
| ExtendedAnsiSQL=1 | This setting enables the new features. |
The attribute can also be set in a DSN through the Advanced Options dialog box when configuring a DSN through Control Panel.
Setting the attribute to 0 disables the new features; setting it to 1 enables the new features.
The attribute can also be set using SQLSetConnectAttr(). The attribute value is 65501 and is set to a SQLINTEGER value of 1 or 0, as documented in the preceding table. It can be called before or after connecting, but it is better to call it after connecting because of the order in which the driver processes cached connection attributes and connection strings.