Kbase P6463: ODBC test connect to database hangs due to broker configuration in Progress Explorer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/27/2010 |
|
Status: Verified
SYMPTOM(s):
Trying to OBDC connect from PC client to database server.
Using Progress Explorer/Adminserver to start the database broker.
ODBC Test Connect hangs
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
CAUSE:
The option to service both 4GL and SQL client is not enabled. To confirm check the database log. The following is a sample entry:
02:31:19 BROKER 0: Maximum Servers Per Broker (-Mpb): 4. (5647)
02:31:19 BROKER 0: Minimum Port for Auto Servers (-minport): 1025. (5648)
02:31:19 BROKER 0: Maximum Port for Auto Servers (-maxport): 2000. (5649)
02:31:19 BROKER 0: This broker supports 4GL server groups only. (8863)
02:31:19 BROKER 0: Created shared memory with segment_id: 24 (9336)
02:31:21 BIW 5: Started. (2518)
02:31:23 WDOG 6: Started. (2518)P
FIX:
From Progress Explorer, under the properties of the defined server group (eg. defaultServerGroup), change the client type from 4GL Only to Both 4GL and SQL.