Exceeding permissible number of connections

[cpsarathy]

i use the following connrction string for my .net web service

string sConnstring = string.Empty;
OdbcConnection conn = null;
DataSet dsPRDB = null;
try
{
sConnstring = "DRIVER={MERANT 3.60 32-BIT Progress SQL92 v9.1C};UID=test;Pwd=;DB=testdb;PORT=40005;HOST=182.163.12.9";

conn = new OdbcConnection(sConnstring);
dsPRDB = new DataSet();
OdbcCommand cmd = new OdbcCommand();
conn.Open();
cmd.Connection = conn;
cmd.CommandText = "select xxserdb_dbid as DatabaseName from pub.xxserdb_ctrl where xxserdb_type='Prod'";
OdbcDataAdapter dr = new OdbcDataAdapter(cmd);
dr.Fill(dsPRDB);
}
catch (Exception ex)
{
ErrorLog("C:\\WS_ErrorLog\\ErrorLog", ex.Message, "GetProductionDatebase");
}
finally
{
conn.Close();
conn.Dispose();
}


but i get an error

ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented.
ERROR [HY000] [MERANT][ODBC PROGRESS driver][PROGRESS]Exceeding permissible number of connections
ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed.
ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented.
ERROR [HY000] [MERANT][ODBC PROGRESS driver][PROGRESS]Exceeding permissible number of connections
ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed.

i feel it happens because the number of connection exceeded, can i stop this by use coneection pooling if possible how can it be done

 

[Casper]

You need to set up an extra database broker for sql connections. There are many threads here where it is described and there are also many entries in the KB on this. (http://progress.atgnow.com/esprogress/categoryBrowse.do)
Search for exceeding permissible and you find the articles. In 9.1C the sql broker needs to be the main broker and not the secondary if I am not mistaken. So try to find articles which describe sql access prior to 9.1D.

And I feel I have to warn you: upgrade to at least 9.1E04 or be prepared to get lots of problems using sql on that particular database.

Casper.