Salesforce

Error 1432 with errno 0 due to auto-connect record in database

« Go Back

Information

 
TitleError 1432 with errno 0 due to auto-connect record in database
URL NameP48984
Article Number000149671
EnvironmentProduct: Progress
Version: 9.1x
Product: OpenEdge
Version: 10.x, 11.x
OS: Windows
Question/Problem Description
Client Server connections fail with error 1432 errno 0
Self service connection to multiple databases fails with error 704

 
Steps to Reproduce
Clarifying Information
When connected as last database in sequence, connection works to both databases.
Error Message** Could not connect to server for database <DATABASE>, errno 0. (1432)
** Could not connect to server for database <DATABASE>, errno <ERRNO>. (1432)
** There is no server active for database <database> on -H <hostname> -S <servicename>. (704)
Defect Number
Enhancement Number
Cause
Database contains an Auto-Connect list, and the connection parameters specified for the auto-connect don't match the parameters that the database was started with.
 
Resolution
Ensure that the connection parameters in the Auto-Connect record match the parameters used when starting the database.
Auto-Connect list can be accessed via Data Administration > Utilities > Edit PROGRESS Auto-Connect List

Auto-Connect is a Progress feature that uses information stored in a primary application database (popo) to connect to a second application database (papa). This
occurs when data from the second database is referenced in a compiled application at run time. The primary application database contains the database connection information for the second database. It must already be connected before Progress can execute the auto-connect for the second application database. Progress executes an auto-connect immediately prior to running a pre-compiled procedure that accesses a database on the auto-connect list.


Example:

1. prodb papa sports
2. prodb popo sports
3. proserve papa
4. proserve popo

5. Add the Auto-Connect information from popo to papa:
$   prowin32 popo -p _admin.p

Data Administration > Utilities > Edit OpenEdge Auto-Connect List...

Databases: papa
Physical Name: <fullpath>\papa
CONNECT-Statement Parameters: -S 6464

6. prowin32 -db papa -db popo connects self-service to each database.
7. prowin32 -db popo -db papa returns the 1432 or 704:

** Could not connect to server for database papa, errno 0. (1432)
** There is no server active for database papa on -H <hostname> -S 6464. (704) 

8. If papa is restarted with -S 6464 to match the Auto-Connect parameters, then prowin32 -db sports2 -db sports1 connects ok

 

Workaround
Notes
Keyword Phrase
Last Modified Date6/16/2017 8:04 AM

Powered by