Kbase P29886: How to configure ODBC driver to be to able update records in Progress database using 3rd party softw
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/29/2004 |
|
Status: Verified
GOAL:
How to configure ODBC driver to be to able update records in Progress database using 3rd party software and SQL-89 ?
GOAL:
How to configure ODBC driver to be to able update records in Progress database using MS Access and SQL-89 ?
FACT(s) (Environment):
MERANT 3.XX 32-BIT Progress SQL-89
Progress 8.x
FIX:
When configuring DSN for Merant ODBC driver, go to ODBC Data Source Administrator -> System DSN -> Configure -> ODBC Progress Driver Setup -> Advanced tab and change "Default Isolation level" from SQL_TXN_READ_UNCOMMITTED to SQL_TXN_READ_COMMITTED.
At least Progress 8.X client networking license is required on the client side.