Kbase 19966: ODBC Dsrv 9.1A parms: async_enable, autocommit, txn_isolation
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/14/2006 |
|
Status: Unverified
GOAL:
What connection parameters should be used when connecting to MS SQL Server and Sybase databases using ODBC DataServer 9.1A05?
GOAL:
Sybase
FACT(s) (Environment):
Progress 9.1A
ODBC Dataserver
MS SQL Server
FIX:
In order to connect to these non-Progress datasources, specific connection parameters must be used. These parameters are based on the data source and driver being used.
For MS SQL Server 6 & 7 with Merant 3.11/3.5 Driver and earlier
-------------------------------------------------------------
Connection parameter"ASYNC_ENABLE,0" is set by default and does not need to be specifed when connecting to this data source
For Sybase with Sybase Drivers
--------------------------------
Connection parameter"ASYNC_ENABLE,0" is set by default and does not need to be specifed when connecting to this data source
For Sybase and MS SQL Server
----------------------------
The "TXN_ISOLATION" parmeter can be set but has limited affect due to the AUTOCOMMIT requirement.
"AUTOCOMMIT,1" connection parameter with ODBC Dsrv is required.
The connection parameter "TXN_ISOLATION" can be set. The TXN_ISOLATION levels are 1, 2, 4, and 8.