Kbase P185366: Do two connections using the same ODBC DSN share any resources?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/5/2011 |
|
Status: Unverified
GOAL:
Do two connections using the same ODBC DSN share any resources?
GOAL:
Do two connections through the same ODBC DSN experience thread contention?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
An ODBC DSN is purely a source of information about how to connect to the database. The DSN itself is not a resource and is not subject to contention, nor is it bound to any specific server side resource. Two ODBC connections through the same DSN do not experience contention for the same thread.
It is possible for the DSN to specify connection attributes, such as default isolation level and fetch array size, which affect server side resource allocation. Use of these attributes is a customer choice.