Kbase P96964: How to configure the ODBC driver for read only on UNIX?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to configure the ODBC driver for read only on UNIX?
GOAL:
How do I set up ODBC on UNIX to be read only?
GOAL:
How to edit the ODBC.INI file so the connection will be read-only?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
UNIX
FIX:
To configure an ODBC connection to read only, change the Transaction Isolation Level to READ UNCOMMITTED. When an ODBC client connects to a database with a transaction isolation level of Read Uncommitted transactions will only be allowed to fetch data. No updates, deletes, or inserts of data can occur using this isolation level.
To modify the transaction isolation level on UNIX, modify the odbc.ini file. The odbc.ini contains the connection parameters for a UNIX ODBC client.
Under the section titled [ODBC Data Sources] in the odbc.ini file modify the parameter DefaultIsolationLevel under the desired ( DSN ) Data Source Name.
Ensure when modifying this file to avoid using environment variables. This file cannot contain any references to environment variables.
Example using the Data Source Name (DSN) mytest:
[mytest]
Driver=/usr/dlc/odbc/lib/pgpro915.so
DatabaseName=sports
PortNumber=7077
HostName=hostname
LogonID=sysprogress
Password=sysprogress
APILevel=1
ConnectFunctions=YYN
CPTimeout=60
DriverODBCVer=03.60
FileUsage=0
SQLLevel=0
UsageCount=1
ArraySize=50
DefaultLongDataBuffLen=2048
DefaultIsolationLevel=READ UNCOMMITTED
LogonID=sysprogress
StaticCursorLongColBuffLen=4096