Advanced tab

If set to -1, the driver uses the maximum packet size that is set by the database server.

If set to 0, the driver uses the default packet size that is used by the database server.

If set to x, an integer from 1 to 127, the driver uses a packet size that is a multiple of 512 bytes. For example, PacketSize=8 means to set the packet size to 8 * 512 bytes (4096 bytes).

Default: -1

Default: None

If set to -1, the connection request does not time out. The driver silently ignores the SQL_ATTR_LOGIN_TIMEOUT attribute.

If set to 0, the connection request does not time out, but the driver responds to the SQL_ATTR_LOGIN_TIMEOUT attribute.

If set to x, the connection request times out after the specified number of seconds unless the application overrides this setting with the SQL_ATTR_LOGIN_TIMEOUT attribute.

Default: 15

If set to -1, the query does not time out. The driver silently ignores the SQL_ATTR_QUERY_TIMEOUT attribute.

If set to 0, the query does not time out, but the driver responds to the SQL_ATTR_QUERY_TIMEOUT attribute.

If set to x, all queries time out after the specified number of seconds unless the application overrides this value by setting the SQL_ATTR_QUERY_TIMEOUT attribute.

Default: 0

If disabled, the driver does not send lightweight SQL operations the database to keep the connection open. Once a connection is idle for the duration specified by the Azure SQL Gateway or database, the connection times out.

If enabled, the driver periodically sends lightweight SQL operations to the database to keep the connection active. Once a connection is idle for the duration specified by the Socket Idle Time option, the driver executes a lightweight query (Select 0) to the database to prevent the connection from timing out.

Default: Disabled

Default: 1500

If set to 0 - Disabled, all server-side scrollable cursors are disabled for the data source. Forward-only cursors on the server-side are enabled.

If set to 1 - Enable All Except Forward Only, all server-side scrollable cursors are enabled for the data source, while forward-only cursors on the server side are disabled.

If set to 2 - Enable Forward Only for Rowset Size >1, only forward-only cursors are enabled on the server-side when the rowset size set to a value greater than one.

If set to 3 - Enable All, all server-side cursors, scrollable and forward-only, are enabled for the data source.

If set to 4 - Enable Forward Only for Select For Update, forward-only cursors on the server-side are enabled only for Select For Update statements. For other Select statements, the driver uses forward-only cursors on the client-side. This setting avoids using driver emulation for other Select statements, thereby improving performance and allowing the use of native updatable result sets.

Default: 1 - Enable All Except Forward Only

If set to 0 - Ignore Errors, the driver substitutes 0x1A for each character that cannot be converted and does not return a warning or error.

If set to 1 - Return Error, the driver returns an error instead of substituting 0x1A for unconverted characters.

If set to 2 - Return Warning, the driver substitutes 0x1A for each character that cannot be converted and returns a warning.

Default: 0 - Ignore Errors

See Using the XML data type for further information about the XML data type.

If set to -4 - SQL_LONGVARBINARY, the driver uses the description SQL_LONGVARBINARY for columns that are defined as the XML data type.

If set to -10 - SQL_WLONGVARCHAR, the driver uses the description SQL_WLONGVARCHAR for columns that are defined as the XML data type.

Default: -10 - SQL_WLONGVARCHAR

If set to 0 - READWRITE, the driver connects to a read-write node in the Always On environment.

If set to 1 - READONLY, the driver requests read-only routing and connects to the read-only database replicas specified by the server.

Default: 0 - READWRITE

When enabled, the driver sets four ANSI-defined behaviors for handling NULL comparisons: NULLS, character data padding, warnings, and NULL concatenation.

When disabled, ANSI-defined behaviors are not exposed. If the driver appears to be truncating trailing blank spaces, disable this attribute.

Default: Enabled

If enabled, the driver returns column values with the timestamp with time zone data type as the ODBC type SQL_TYPE_TIMESTAMP. The time zone information in the fetched value is truncated. Use this value if your application needs to process values the same way as TIMESTAMP columns.

If disabled, the driver returns column values with the timestamp with time zone data type as the ODBC data type SQL_VARCHAR. Use this value if your application requires the time zone information in the fetched value.

Default: Disabled.

If enabled, the driver works with single-threaded and multi-threaded applications.

If disabled, the driver does not work with multi-threaded applications. If using the driver with single-threaded applications, this value avoids additional processing required for ODBC thread-safety standards.

Default: Enabled

Determines whether the driver returns column values with the time data type as the ODBC data type SQL_TYPE_TIME or SQL_TYPE_TIMESTAMP.

Supported only for Microsoft SQL Server 2008.

If enabled, the driver returns column values with the time data type as the ODBC data type SQL_TYPE_TIME. The fractional seconds portion of the value is truncated.

If disabled, the driver returns column values with the time data type as the ODBC data type SQL_TYPE_TIMESTAMP. The fractional seconds portion of the value is preserved. Time columns are not searchable when they are described and fetched as timestamp.

If set to enabled, the driver returns all results, including results that are generated by triggers. Multiple trigger results are returned one at a time. You can use the SQLMoreResults function to return individual trigger results. Warnings and errors are reported in the results as they are encountered.

If disabled:

• For Microsoft SQL Server 2005 and higher and Windows Azure SQL Database, the driver does not report trigger results if the statement is a single INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, GRANT, REVOKE, or DENY statement.
• For other Microsoft SQL Server databases, the driver does not report trigger results if the statement is a single INSERT, UPDATE, or DELETE statement.

Default: Disabled

If disabled, the driver does not enable TCPKeepAlive.

If enabled, the driver enables TCPKeepAlive.

Default: Disabled

If enabled, the database enforces ANSI rules regarding quotation marks. Double quotation marks can only be used for identifiers, such as column and table names. Character strings must be enclosed in single quotation marks, for example:

SELECT "au_id"
FROM "authors"
WHERE "au_lname" = 'O''Brien'

If disabled, applications that use quoted identifiers encounter errors when they generate SQL statements with quoted identifiers.

Allows your application to use the snapshot isolation level if your Microsoft SQL Server database is configured for Snapshot isolation. Supported only for Microsoft SQL Server 2005 and higher.

See Using the Snapshot isolation level for details about using the snapshot isolation level.

When enabled and your application has the transaction isolation level set to serializable, the application uses the snapshot isolation level.

When disabled and your application has the transaction isolation level set to serializable, the application uses the serializable isolation level.

Default: Disabled

If enabled, the driver allows explicit inserts on IDENTITY columns defined as NOT FOR REPLICATION.

If disabled, the driver enforces constraints on IDENTITY columns imposed by the NOT FOR REPLICATION flag.

Default: Disabled.