I have been having difficulties setting up an ODBC Data Source using the Merant driver under Progress 9.1B Progress informs me that there is no need to start up a separate ODBC Broker for Progress 9.0+ but when I try to connect to a database via ODBC Data Sources in Control Panel (and yes, I've verified the parameters), I get either "Database not connected" or "Exceeding permissible number of connections". When I look at the log file of the database, I see the following relevant lines:
12:03:00 BROKER 0: Maximum Number of Servers (-Mn): 11. (4258)
12:03:00 BROKER 0: Minimum Clients Per Server (-Mi): 8. (4259)
12:03:00 BROKER 0: Maximum Number of Users (-n): 21. (4260)
12:03:00 BROKER 0: Host Name (-H): TOTAL-E250. (4261)
12:03:00 BROKER 0: Service Name (-S): guic2sv. (4262)
12:03:00 BROKER 0: Network Type (-N): TCP. (4263)
12:03:00 BROKER 0: Character Set (-cpinternal): ISO8859-1. (4264)
12:03:00 BROKER 0: Parameter File: /total/ultima/gui/scripts/c2-st.pf.
(4282)
12:03:00 BROKER 0: Minimum Port for Auto Servers (-minport): 1025. (5648)
12:03:00 BROKER 0: Maximum Port for Auto Servers (-maxport): 2000. (5649)
12:03:00 BROKER 0: This broker supports both 4GL and SQL server groups.
(8865)
12:03:00 BROKER 0: Created shared memory with segment_id: 2268 (9336)
12:03:00 BROKER 0: Created shared memory with segment_id: 2269 (9336)
12:03:00 BROKER 0: Created shared memory with segment_id: 2170 (9336)
12:03:00 BROKER 0: Created shared memory with segment_id: 2171 (9336)
12:03:00 BROKER 0: Created shared memory with segment_id: 2172 (9336)
12:03:00 BROKER 0: Created shared memory with segment_id: 2173 (9336)
12:03:00 BROKER 0: Created shared memory with segment_id: 2074 (9336)
12:03:03 Usr 15: Login by proadm on batch. (452)
12:03:04 Usr 15: Userid is now rep901. (708)
12:03:54 BROKER 0: SQL server process terminated. (8841)
14:57:28 BROKER 0: SQL server process terminated. (8841)
It seems that the broker is supposed to support SQL server groups, but, if I
compare it to the log of another site, I see that there should be another
line referring to the startup of the SQL ODBC Server which is missing in our
startup. Also, the SQL ODBC connect is attempted at the correct database,
but it is not successful. If anyone can help in this it would be appreciated as Progress has not been able to give a solution yet.
Regards,
Randal Frankwick
Randal,
I don't think you explained enough details
about your setup over there and what you are
trying to do. Are you trying to connect to
a database running on a remote system?
Are these Windows based systems or Unix based
systems?
Anyway, if I were you I will try to enter the
user id in the ODBC setup field. You should
enter the owner of the database that you are
trying to connect to, I think.
I didn't try that with Excel, but I was able to
connect to a Progress database running on a
Unix machine from Access running on a Windows NT.
Don't forget to enter the remote machine's
name and IP address in the host file if you
haven't done it yet.
Good luck.
michael kim
"Randal Frankwick" wrote:
>
>I have been having difficulties setting up an ODBC Data
>Source using the Merant driver under Progress 9.1B Progress
>informs me that there is no need to start up a separate
>ODBC Broker for Progress 9.0+ but when I try to connect
>to a database via ODBC Data Sources in Control Panel
>(and yes, I've verified the parameters), I get either
>"Database not connected" or "Exceeding permissible number
>of connections". When I look at the log file of the
>database, I see the following relevant lines:
>
>12:03:00 BROKER 0: Maximum Number of Servers (-Mn): 11.
>(4258)
>12:03:00 BROKER 0: Minimum Clients Per Server (-Mi):
>8. (4259)
>12:03:00 BROKER 0: Maximum Number of Users (-n): 21.
>(4260)
>12:03:00 BROKER 0: Host Name (-H): TOTAL-E250. (4261)
>12:03:00 BROKER 0: Service Name (-S): guic2sv. (4262)
>12:03:00 BROKER 0: Network Type (-N): TCP. (4263)
>12:03:00 BROKER 0: Character Set (-cpinternal): ISO8859-1.
>(4264)
>12:03:00 BROKER 0: Parameter File: /total/ultima/gui/scripts/c2-st.pf.
>(4282)
>12:03:00 BROKER 0: Minimum Port for Auto Servers (-minport):
>1025. (5648)
>12:03:00 BROKER 0: Maximum Port for Auto Servers (-maxport):
>2000. (5649)
>12:03:00 BROKER 0: This broker supports both 4GL and
>SQL server groups.
>(8865)
>12:03:00 BROKER 0: Created shared memory with segment_id:
>2268 (9336)
>12:03:00 BROKER 0: Created shared memory with segment_id:
>2269 (9336)
>12:03:00 BROKER 0: Created shared memory with segment_id:
>2170 (9336)
>12:03:00 BROKER 0: Created shared memory with segment_id:
>2171 (9336)
>12:03:00 BROKER 0: Created shared memory with segment_id:
>2172 (9336)
>12:03:00 BROKER 0: Created shared memory with segment_id:
>2173 (9336)
>12:03:00 BROKER 0: Created shared memory with segment_id:
>2074 (9336)
>12:03:03 Usr 15: Login by proadm on batch. (452)
>12:03:04 Usr 15: Userid is now rep901. (708)
>12:03:54 BROKER 0: SQL server process terminated. (8841)
>14:57:28 BROKER 0: SQL server process terminated. (8841)
>
>It seems that the broker is supposed to support SQL server
>groups, but, if I
>compare it to the log of another site, I see that there
>should be another
>line referring to the startup of the SQL ODBC Server which
>is missing in our
>startup. Also, the SQL ODBC connect is attempted at the
>correct database,
>but it is not successful. If anyone can help in this
>it would be appreciated as Progress has not been able
>to give a solution yet.
>
>Regards,
>
>Randal Frankwick
>