Kbase P24081: What are the default value and functionalities of async_enable in MS SQL dataserver?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/10/2008 |
|
Status: Unverified
GOAL:
What are the default value and functionalities of async_enable in MS SQL dataserver?
FACT(s) (Environment):
Windows
WebSpeed 3.1D
MS SQL DataServer
FIX:
By default, async_enable is set to 0 for MS SQL server dataserver.
By default, all drivers execute ODBC functions synchronously; that is, an application calls a function and the driver does not return control to the application until that function has finished executing.
However, some functions can be executed asynchronously, that is, an application calls a function and the driver, after performing some minimal processing,
returns control to the application. The application can then call other functions while the first function is still executing. Asynchronous execution is
most useful when the function being executed takes a considerable amount of time to complete.