Consultor Eletrônico



Kbase P20102: Test connect fails for SQL 89 to Unix database.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   28/03/2005
Status: Unverified

FACT(s) (Environment):

UNIX
MERANT 4.0 32-BIT Progress SQL-89
MERANT 3.70 32-BIT Progress SQL-89
MERANT 3.60 32-BIT Progress SQL-89
MERANT 3.50 32-BIT Progress SQL-89

SYMPTOM(s):

SQL-89 connection to database fails

Errors appear in the prooidrv.lg file:

BROKER: PROOIDRV variable does not contain Open Access Driver module. (2660)

Error establishing Open Interface Driver connection. (2575)

BROKER could not execute <_prooidv>. (1155)

CAUSE:

The PROOIDRV environment variable was lowercase, and not exported. The PROOIBRK and PROOIDRV environment variables must be uppercase and exported.

FIX:

Shutdown the prooibk process and correct the environment variables.

Ensure that the PROOIBRK and PROOIDRV environment variables are pointing the correct path, and that they are exported.

Example of the PROOIBRK and PROOIDRV environment variables been set:

PROOIBRK=/usr/dlc/bin/_prooibk; export PROOIBRK
PROOIDRV=/usr/dlc/bin/_prooidv; export PROOIDRV