title: "SQLSetEnvAttr | Microsoft Docs" ms.custom: "" ms.date: "03/16/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.service: "" ms.component: "native-client-odbc-api" ms.reviewer: "" ms.suite: "sql" ms.technology:
ms.tgt_pltfrm: "" ms.topic: "reference" apitype: "DLLExport" helpviewer_keywords:
- "SQLSetEnvAttr function" ms.assetid: d4114571-feca-4330-b2e4-7bfd1050b812 caps.latest.revision: 32 author: "MightyPen" ms.author: "genemi" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] [!INCLUDESNAC_Deprecated]
The ODBC Programmer's Reference defines how ODBC drivers should interpret the SQLSetEnvAttr attribute specifications from applications written to either the ODBC 2.x or ODBC 3.x API. The [!INCLUDEssNoVersion] Native Client ODBC driver complies with those rules.
One of the attributes controlled by SQLSetEnvAttr is whether connection pooling is to be used. If connection pooling is used with the [!INCLUDEssNoVersion] Native Client ODBC driver, the DriverCompletion parameter must be set to SQL_DRIVER_NOPROMPT when connecting with either SQLDriverConnect or SQLConnect.