using-the-extendedansisql-connection-string-attribute-access-driver.md

title	Using the ExtendedAnsiSQL Connection String Attribute | 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	Access driver [ODBC], ExtendedAnsiSql extendedANSISQL [ODBC] extendedANSISQL [ODBC], about ExtendedAnsiSQL
ms.assetid	92675c30-9100-43ae-aa35-041f3006a54f
author	David-Engel
ms.author	v-daenge

Using the ExtendedAnsiSQL Connection String Attribute (Access Driver)

Jet 4.0 has several new features that are not enabled by default in the ODBC Desktop Database Drivers version 4.0. To take advantage of these new features, an application will have to set a new connection attribute, add a new attribute to the connection string, or set the attribute in a DSN. The attribute is called ExtendedAnsiSQL and pertains only to the Microsoft ODBC Desktop Database Drivers 4.0 and later.

This section contains the following topics.

• Setting ExtendedAnsiSQL

• Enabling New Data Types by Setting ExtendedAnsiSQL

• Creating and Dropping Views and Procedures Using ExtendedAnsiSQL

• Data Trunctation Detection Enabled Using ExtendedAnsiSQL

• Jet 4.0 Uses SQL-92 Reserved Words List when ExtendedAnsiSQL Set