Exceding connections in SQL92 ODBC driver

[Osmar Morais]

I´m having the following message when I try to connect the database from MS-Query:

"[MERANT][ODBC PROGRESS driver] Driver´s SQLSetConnectAttr failed. [MERANT][ODBC PROGRESS driver] optional feature not implemented. [MERANT][ODBC PROGRESS driver] Exceding permissible number of connections."

I´ve already increased the "-n" startup parameter but the problem remains. Someone can help me with this?

 

[MurrayH]

I do seem to remember this, it was a bug in something and need a patch, either Progress, MDAC drivers, Windows or Office. Can't remember exactly, sorry.

Murray

 

[Fabrice]

Another suggestion would be to increase the -Mn startup parameter as well.

 

[RichardThorp]

OK,

Dependant on your exact Progress version, you may need to start a secondary login broker to service 4GL clients.

Remember that -Ma and -Mn need to be set, not just -n.

A progress server (-Ma) can currently only service 1 SQL-92 client, and not (-Mn) SQL-92 clients.

For example, a progress database broker started with -n 20, -Ma 5 and -Mn 4, will only service 5 SQL-92 clients rather than 20. With this config, it will service either

-20 4GL
-1 SQL and 16 4GL
-2 SQL and 12 4GL
-3 SQL and 8 4GL
-4 SQL and 4 4GL
-5 SQL

There are some excellent Progress Kbases on this issue.

Richard