Apptivity Progress db OpenLink -When all else fails try this
1. Rename your oplrqb.ini file to oplrqb.old.
2. Copy the text between the "*****" symbols and save it as oplrqb.ini
Place this in your openlink install directory, by default:
c:\program files\openlink\bin
3. Check the tableview .dat file you are using to ensure that it has
data (make sure the size of the file is not zero bytes). See kbase
18051 Configuring OpenLink for use with Apptivity -debugging tips,
for more information on this.
4. Modify the oplrqb.ini file as follows: In the
[Environment Progress82a] section change the location of the
TABLEVIEW setting to point to your .dat file.
This assumes that you have installed progress into C:\DLC
5. Shut down the OpenLink Request Broker.
6. Start the Request Broker in debug mode by typing oplrqb -dv in
a DOS box. This will output debugging messages to a window.
7. Start up the "C++ demo 32 bit" from the OpenLink program group
You should be able to connect to your Progress ODBC DSN
;*****Start of oplrqb.ini file.
;
; oplrqb.ini
;
; $Id: oplrqb.ini,v 1.3 1998/01/29 15:25:14 openlink Exp $
;
; Configuration file for the OpenLink Request Broker
;
[Request Broker]
BinaryDirectory = C:/PROGRAM FILES/OPENLINK/BIN
CommandLine = ;+debug
Protocols = tcp
;MaxAgents=0 ; if >0, max. # of processes spawned by broker
;MaxConnections=0 ; if >0, max. # of connections from clients
[Protocol TCP]
PingWatchdog = No ; Send check-alive packets
PingInterval = 600 ; every <PingInterval> seconds
;IPAddress=127.0.0.1 ; Overrules found interface address
PortLow = 5000
PortHigh = 5020
[Protocol SPX]
SAPBroadcast = Yes ; Broadcast SAP registration packets
SAPInterval = 100 ; every <SAPInterval> seconds
SAPServiceType = 0x321F ; with type <SAPServiceType>
SAPServiceName = OPENLINK ; and with name <SAPServiceName>
HostFile = HOSTS.IPX ; For IPX/SPX name to address translation
[Communications]
SendSize = 16000 ; Send buffer size
ReceiveSize = 4096 ; Receive buffer size
DataEncryption = No ; Crypting of outgoing packets
BrokerTimeout = 60 ; Timeout for utilities to contact the broker
ReceiveTimeout = 30 ; Maximum time allowed for for OpenLink Service
; Agents
; (JDBC_SV, ODBC_SV, PROXY_SV) to instigate session
; with DB agents (ora7_sv, inf7_sv etc.)
[Security]
StartupBy = .* ; users who can startup oplrqb
ShutdownBy = .* ; users who can shutdown oplrqb
ShutdownFrom = .* ; hostnames that can shutdown
;TraceRulebook=debug.bk ; Write merged rulebook (debug)
;IncludeRulebook=samplesv.bk ; Default location in BinaryDirectory
[Environment SQLSERVER4]
Path = C:\SQL\DLL;C:\WINDOWS\SYSTEM32
[Environment SQLSERVER6]
Path = C:\MSSQL\DLL;C:\WINNT\System32
[Environment ORACLE7]
Path = C:\ORANT\BIN;C:\WINNT\System32
ORACLE_HOME = D:\ORANT
;ODBC_CATALOGS=Y ; Uncomment after loading odbccat7.sql
;MULTIPLEX_LDA=5 ; Allow 5 OpenLink clients on a single lda
[Environment ORACLE8]
Path = C:\ORANT\BIN;C:\WINDOWS\SYSTEM32
ORACLE_HOME = C:\ORANT
;ODBC_CATALOGS=Y ; Uncomment after loading odbccat7.sql
;MULTIPLEX_LDA=5 ; Allow 5 OpenLink clients on a single lda
[Environment SYBASE10]
DSQUERY = SYBASE
SYBASE = C:\SYBASE
Path = C:\SYBASE\DLL;C:\WINNT\System32
[Environment INFORMIX5]
INFORMIXDIR = C:\Informix
Path = C:\Informix\BIN;C:\WINNT\System32
TBCONFIG = tbconfig
[Environment INFORMIX7]
INFORMIXSERVER = online7
INFORMIXDIR = C:\Informix
Path = C:\Informix\BIN;C:\WINNT\System32
ONCONFIG = ONCONFIG
DELIMIDENT = Y ; Allow quoted identifiers
[Environment OPENINGRES1]
II_DATE_FORMAT = us
II_SYSTEM = C:\OPENINGRES
ING_SET = set lockmode session where readlock=nolock
Path = C:\Ingres\BIN;C:\WINNT\System32
[Environment OPENINGRES2]
II_DATE_FORMAT = us
II_SYSTEM = C:\OPENINGRES
ING_SET = set lockmode session where readlock=nolock
Path = C:\Ingres\BIN;C:\WINNT\System32
[Environment DB2]
DB2PATH =
DB2INSTANCE =
[Environment KUBL]
Path = C:\KUBL\BIN;C:\WINNT\System32
[Environment PROGRESS81A]
DLC = C:\DLC
Path = C:\DLC\BIN;C:\WINNT\SYSTEM32
;TABLEVIEW=
;TABLEVIEW_QUALIFIER=Y
;DEADLOCK_TIMEOUT=60 ; Seconds to wait for lock to release
;INSERT_LOGICAL=Y
;UPDATE_LOGICAL=Y
;MIN_FIELD_LEN=
[Environment PROGRESS82A]
DLC = C:\DLC
Path = C:\DLC\BIN;C:\WINDOWS\SYSTEM
TABLEVIEW= c:\82cwork\tableview.dat
;TABLEVIEW_QUALIFIER=Y
;DEADLOCK_TIMEOUT=60 ; Seconds to wait for lock to release
;INSERT_LOGICAL=Y
;UPDATE_LOGICAL=Y
;MIN_FIELD_LEN=
[Environment JDBC]
UDBCINI = C:\Program Files\OpenLink\bin\UDBC.INI
[Domain Aliases]
jodbc = jodbc
judbc = judbc
jdbc = jdbc
DB2 = db2
Kubl = kubl
ODBC = odbc
Proxy = pxy
Oracle 7 = ora7
Oracle 8 = ora8
Sybase 10 = syb10
SQLServer 4 = sql4
SQLServer 6 = sql6
Informix 5 = inf5
Informix 7 = inf7
OpenIngres 1.x = oig1
OpenIngres 2.x = oig2
^Progress 81A$ = pro81a
^Progress 81AS$ = pro81as
^Progress 82A$ = pro82a
^Progress 82AS$ = pro82as
[Opsys Aliases]
java = java
[Application Aliases]
MSACCESS|EXCEL|MSQRY32 = msoffice
[Mapping Rules]
*:*:Admin:msdos:*:msaccess:* = reject Admin user account is not regist
ered
jodbc:*:*:java:*:*:* = accept jodbc_client
judbc:*:*:java:*:*:* = accept judbc_client
jdbc:*:*:java:*:*:* = accept jdbc_client
odbc:*:*:*:*:*:* = accept generic_odbc
pxy:*:*:*:*:*:* = accept generic_proxy
ora7:*:*:*:*:msoffice:* = accept generic_ora7_msoffice
ora8:*:*:*:*:msoffice:* = accept generic_ora8_msoffice
syb10:*:*:*:*:*:* = reject The Sybase 10 Database Agent is not config
ured
sql4:*:*:*:*:*:* = reject The SQLServer 4 Database Agent is not confi
gured
sql6:*:*:*:*:*:* = reject The SQLServer 6 Database Agent is not confi
gured
inf5:*:*:*:*:*:* = reject The Informix 5 Database Agent is not config
ured
inf7:*:*:*:*:*:* = reject The Informix 7 Database Agent is not config
ured
oig1:*:*:*:*:*:* = reject The OpenIngres 1.x Database Agent is not con
figured
oig2:*:*:*:*:*:* = reject The OpenIngres 2.x Database Agent is not con
figured
pro81a:*:*:*:*:*:* = reject The Progress 8.1A Database Agent is not co
nfigured
pro81as:*:*:*:*:*:* = reject The Progress 8.1A Database Agent is not c
onfigured
pro82a:*:*:*:*:*:* = accept generic_pro82a
pro82as:*:*:*:*:*:* = reject The Progress 8.2A Database Agent is not c
onfigured
kubl:*:*:*:*:*:* = accept generic_kubl
[jodbc_client]
Program = jodbc_sv.exe
CommandLine = ;+debug
ReUse = always
;Environment=
;ConnectOptions=
;Directory=c:\temp
;Database=
;Userid=
;Password=
;ReadOnly=Yes
[judbc_client]
Program = judbc_sv.exe
CommandLine = ;+debug
Environment = JDBC
ReUse = always
;ConnectOptions=
;Directory=c:\temp
;Database=
;Userid=
;Password=
;ReadOnly=Yes
[jdbc_client]
Program = jodbc_sv.exe
CommandLine = ;+debug
ReUse = always
;Environment=
;ConnectOptions=
;Directory=c:\temp
;Database=
;Userid=
;Password=
;ReadOnly=Yes
[generic_ora7_msoffice]
Program = ora7_sv.exe
Environment = ORACLE7
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
CommandLine = +jetfix
;Database=
;UserID=
;Password=
[generic_ora7]
Program = ora7_sv.exe
Environment = ORACLE7
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
;UserID=
;Password=
[generic_ora8_msoffice]
Program = ora8_sv.exe
Environment = ORACLE8
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
CommandLine = +jetfix
;Database=
;UserID=
;Password=
[generic_ora8]
Program = ora8_sv.exe
Environment = ORACLE8
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
;UserID=
;Password=
[generic_syb10]
Program = syb10_sv.exe
Environment = SYBASE10
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
;UserID=
;Password=
[generic_sql4]
Program = sql4_sv.exe
Environment = SQLSERVER4
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
;UserID=
;Password=
[generic_sql6]
Program = sql6_sv.exe
Environment = SQLSERVER6
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
;UserID=
;Password=
[generic_inf5]
Program = inf5_sv.exe
Environment = INFORMIX5
OpsysLogin = Yes
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
;UserID=
;Password=
[generic_inf7]
Program = inf7_sv.exe
Environment = INFORMIX7
OpsysLogin = Yes
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
;Userid=
;Password=
[generic_oig1]
Program = oig1_sv.exe
Environment = OPENINGRES1
OpsysLogin = Yes
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
[generic_oig2]
Program = oig2_sv.exe
Environment = OPENINGRES2
OpsysLogin = Yes
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
;UserID=
;Password=
[generic_pro81a]
Program = pro81a_sv.exe
Environment = PROGRESS81A
ServerOptions = -T c:\temp -d mdy -TB 31 -TM 31 -q -NL
; Don't use a different -d argument
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
;UserID=
;Password=
[generic_pro81as]
Program = pro81as_sv.exe
Environment = PROGRESS81A
ServerOptions = -T c:\temp -d mdy -TB 31 -TM 31 -q -NL
; Don't use a different -d argument
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
;UserID=
;Password=
[generic_pro82a]
Program = pro82a_sv.exe
Environment = PROGRESS82A
ServerOptions = -q -d mdy -TB 31 -TM 31
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
;UserID=
;Password=
[generic_pro82as]
Program = pro82as_sv.exe
Environment = PROGRESS82A
ServerOptions = -q -d mdy -TB 31 -TM 31
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
;UserID=
;Password=
[generic_db2]
Program = db2_sv.exe
Environment = DB2
ReUse = ifsame machine, ifsame application
;Directory=c:\temp
;ConnectOptions=
;ReadOnly=
;CommandLine=
;Database=
;UserID=
;Password=
[generic_odbc]
Program = odbc_sv.exe
ReUse = ifsame machine, ifsame application
;CommandLine=
;ConnectOptions=
;Directory=c:\temp
;Database=
;Userid=
;Password=
;ReadOnly=Yes
[generic_kubl]
Program = kubl_sv.exe
ReUse = ifsame machine, ifsame application
Environment = KUBL
;CommandLine=
;ConnectOptions=
;Directory=c:\temp
;Database=
;Userid=
;Password=
;ReadOnly=Yes
[generic_proxy]
Program = proxy_sv.exe
ReUse = ifsame machine, ifsame application
;CommandLine=
;ConnectOptions=
;Directory=c:\temp
;ServerType=
;Host=
;Userid=
;Database=
;Password=
;ReadOnly=Yes
[Persistent Services]
Configurator = www_sv
[www_sv]
Program = w3config/www_sv.exe
Directory = w3config
CommandLine =
;*****End of oplrqb.ini file.