Attribute

ApplicationUsingThreads (AUT)

Purpose

Determines whether the driver uses internal locking mechanisms to ensure that multiple application threads work appropriately when they share an ODBC connection.

Valid Values

0 | 1

Behavior

If set to 1 (Enabled), the driver works with single-threaded and multi-threaded applications. This setting ensures that only a single thread is using an ODBC connection at a time. Until the connection becomes available, attempts by other threads to use the same connection are pended. Use this setting when your application includes multiple threads which share an ODBC connection and the application itself does not synchronize access to the connection.

If set to 0 (Disabled), the driver takes no action to prevent multiple application threads from using the same connection concurrently. This setting avoids the additional processing required for ODBC thread-safety standards. Use this setting when:
  • The application is single threaded
  • The application is multi-threaded and the threads each use their own connection to the database
  • The application is multi-threaded and the threads are not sending statement-executing requests for multiple statements to a single connection at the same time

Notes

  • Depending on the behavior of your application, this connection option can affect performance.

Default

1 (Enabled)

GUI Tab

Advanced tab

See also

Performance considerations