Salesforce

Cannot connect to database in client server mode on the same machine using Development Licenses only

« Go Back

Information

 
TitleCannot connect to database in client server mode on the same machine using Development Licenses only
URL NameP99650
Article Number000152329
EnvironmentProduct: Progress
Version: All supported versions
Product: OpenEdge
Version: All supported versions
OS: All supported platforms
Other: RDBMS, OE Studio
Question/Problem Description
Cannot connect to database in client server mode on the same machine using Development Licenses only.
Getting error 704 or 1432.
Remote clients getting error 1432 when connecting to a database.
Cannot connect to the database in client server mode.
Cannot connect to a DB via TCP using a port number or service name.
Steps to Reproduce
Clarifying Information
Progress Development Studio installed (PDSOE)
OpenEdge Studio license is installed on the machine
OpenEdge Architect license is installed on the machine
Provision license is installed on the machine
Provision Plus license is installed on the machine
 
Error Message** There is no server active for database <database> on -H <hostname> -S <service name>. (704)

Database log shows errors:

This server is licensed for local logins only. (4393)
The -S parameter was ignored. (4394)

** Could not connect to server for database <DATABASE>, errno <ERRNO>. (1432)
Defect Number
Enhancement Number
Cause
Development licenses such as OpenEdge Studio, OpenEdge Architect, Provision, Provision Plus or 4GL Development licenses - contain only the Personal Database as component, which is designed for local logins only.  Therefore only connections from the localhost interface are allowed.

To connect to a database remotely, a Server Networking component is required.  Starting In Progress version 7.3C and later, Server Networking functionality is included in the following products:
  • Workgroup Database Server
  • Enterprise Database Server
  • DataServer products
Resolution

In several support cases, it was found the issue was due to swapping the Production progress.cfg licenses with a Development License which was not reverted when that Consultant had finished their site engagement. Open a PROENV console and run: showcfg to confirm.

Choose one of the following:

1.  If client can access the same machine where the database is, use shared memory connection, ie, use "-db pathtodb/dbname" as db connection string

2.  Use -H localhost for client connection. ie., use "-db dbname -H localhost -S portnumber" or "-db dbname -S portnumber", without the -H (localhost), as connection string from the same machine where the Development license is installed.

Refer to Article: When to use machine-name or IP address or localhost for the value of the connection parameter -H

3.  Add a Workgroup or Enterprise database license to the current installation in order that remote clients can connect to the database. "-db dbname -H [IP | hostname] -S [ portnumber | servicename] " 

Refer to Article: How to add a new product to an existing Progress installation?  

 

Workaround
Notes
Keyword Phrase
Last Modified Date3/15/2021 8:45 AM

Powered by