Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

Windows 2000

FACT(s) (Environment):

Progress 9.1D

FACT(s) (Environment):

CorVu 4.20

SYMPTOM(s):

Error 962 and SQL error when accessing tables from CorVu Knowledge Library

** Table SYSTABLES does not exist or cannot be accessed. (962)

** Table <name> does not exist or cannot be accessed. (962)

SQL follows:
SELECT DISTINCT OWNER FROM SYSPROGRESS.SYSTABLES WHERE OWNER IS NOT
NULL ORDER BY OWNER FOR READ ONLY

Native connection being used from CorVu to Progress

CHANGE:

dbms.kif file was modified to enable ODBC connections

CAUSE:

dbms.kif file was modified to enable ODBC connections, but a server.kif file had not been created. A server.kif file is required if native connections and ODBC connections are to be used at the same time.

FIX:

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].

This should then allow you to connect using the specified native driver while ODBC clients will still be able to connect as well.

See also Accessing SYS and SYSPROGRESS with CorVu Knowledge Library returns error 7587