Consultor Eletrônico

Status: Verified

FACT(s) (Environment):

Progress 9.1x

SYMPTOM(s):

TCP bind error with a Probuilt ESQL-92 client executable.

Error in tcp bind 146

CAUSE:

Attempting to connect to a database without including the correct connection parameters for the client, either in the code within the object that are linked to the Progress executable, or within the Environment Variable DB_NAME. Where these setting are needed depends on what connection method is being used.

FIX:

When connecting an ESQL-92 client, the networking parameters (-S, -H, -N,) have to be specified. There are 2 different ways of specifying the initial connection parameters for the client:

1) Use the following code in the .pc file:

EXEQ SQL
CONNECT TO DEFAULT;

This establishes the connection to a default database. The default database is the one set in the environment variable DB_NAME. In this case, include the full connection details within the environment variable.

DB_NAME=db_type:net_protocol:host_name:port_num:db_name

2) The other method is to define the connection parameters within
the code:

EXEQ SQL
CONNECT TO 'db_type:net_protocol:host_name:port_num:db_name' ;