Kbase P52428: Accessing SYS and SYSPROGRESS with CorVu Knowledge Library returns error 7587
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Windows 2000
Progress 9.1D
CorVu 4.20.184
MERANT 3.60 32-BIT Progress SQL-92
SYMPTOM(s):
Accessing SYS and SYSPROGRESS with CorVu Knowledge Library returns error 7587
State: 37000
Code: -20003
Message: [DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Syntax error (7587)
Connecting to CorVu using ODBC
Only SYS and SYSPROGRESS displayed in Knowledge Library
No tables displayed in Knowledge Library
CAUSE:
CorVu is trying to use the [Progress] instructions instead of the [ProgressSQL92] in the dbms.kif file to execute the Knowledge Library schema download. When using the ODBC connection, Progress has to use the commands under a [ProgressSQL92] tag.
FIX:
Edit the dbms.kif in the CorVu installation directory -
1. Backup dbms.kif.
2. Change [Progress] tag to [xxProgress]
3. Change [ProgressSQL92] tag to [Progress]
If connections using native drivers or ABA servers are to be used as well as ODBC connections, then a server.kif file must also be created to enable this.
To create a server.kif file -
1. Copy and paste the [Progress] and [ProgressSQL92] sections out of the original dbms.kif into a file you then name server.kif
2. In server.kif change the tag name to be the name of the server as defined in the CorVu Administrator, e.g. if you have a Progress-native server defined as "sports91d" in the Administrator, change the [Progress] tag in server.kif to [sports91d].
Thus to enable simultaneous ODBC, native driver and ABA server connections, there must be a dbms.kif file and a server.kif file, modified as described and located in the CorVu installation directory. The dbms.kif contains the modififcation required for the odbc driver to work, while server.kif has the modifications required for the native drivers and ABA servers to work.