Kbase P29130: "Server not reachable or possible RPC error" using 9.1D ODBC driver for HP-UX
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
HP-UX
Progress 9.1D
SYMPTOM(s):
SQLSTATE = S1000
NATIVE ERROR = -20211
MSG = [DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Server not reachable or possible RPC error
Error occurs using 9.1D06
Error occurs when the DefaultIsolationLevel=READ COMMITTED using the 9.1D HP-UX ODBC driver.
FIX:
Progress is aware of this problem. Presently, the only known workaround is setting DefaultIsolationLevel=REPEATABLE READ.
EXAMPLE:
[ODBC Data Sources]
myDSN=Progress_SQL92_Driver
[myDSN]
Driver=/view/rdl91d_hpux1132/vobs_prgs/hpux1132/dlc/odbc/lib/pgpro915.sl
DatabaseName=myDB
PortNumber=1234
HostName=myHPbox
LogonID=PSC
Password=PSC
APILevel=1
ConnectFunctions=YYN
CPTimeout=60
DriverODBCVer=03.60
FileUsage=0
SQLLevel=0
UsageCount=1
ArraySize=50
DefaultLongDataBuffLen=2048
DefaultIsolationLevel=REPEATABLE READ <-------------- INSERT CHANGE HERE
StaticCursorLongColBuffLen=4096
[ODBC]
InstallDir=/view/rdl91d_hpux1132/vobs_prgs/hpux1132/dlc/odbc
Trace=0
TraceFile=odbctrace.out
TraceDll=/view/rdl91d_hpux1132/vobs_prgs/hpux1132/dlc/odbc/lib/odbctrac.sl
UseCursorLib=0