Information

Title	Can the primary Database broker be server type SQL?

URL Name	000029620

Article Number	000149976

Environment	Product: OpenEdge Version: All supported versions Product: Progress Version: 9.1x OS: All supported platforms

Question/Problem Description

Can the primary Database broker be server type SQL?
Can the primary Database broker be -ServerType SQL?
Can I start the primary Database broker as server type SQL?
Can I start the primary Database broker as -ServerType SQL?

Steps to Reproduce

Clarifying Information

Error Message

Defect Number

Enhancement Number

Cause

Resolution

Yes, the primary broker can be either SQL or 4GL with -ServerType specified in the database start-up parameter.

However, If Fathom Management/OpenEdge Management or Fathom Replication/OpenEdge Replication is being used the 4GL Broker is required to be started as the primary broker for the database (refer to the article# 000021731.

For Progress 9.1C or below the primary broker has to be used for SQL-92 connection, because the polling feature of the SQL-92 servers is only active for the primary broker (refer to the article 000001432).

Workaround

Notes

References to other Documentation:

"How to set up a secondary login broker for SQL-92 connections for Progress/OpenEdge database?"
"How to set up a secondary login broker to attend SQL-92 connections for Progress 9.1C and below"

Keyword Phrase

Last Modified Date	11/20/2020 7:39 AM