ORA-00020: maximum number of processes (%s) exceeded

[John G]

I have been using the OleBDhelper
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/daab.asp)
with oracle. With a small group of people we recieved the following
message:
ORA-00020: maximum number of processes (%s) exceeded


Looking at some of the code in the OledbHelper, I noticed that there
was no close method on the connection. Can this be it. Also, I saw from
another user was they also set the connection to null so the garbage
collection would clean up that connection. thanks in advance.
Code:

public static DataSet ExecuteDataset(string connectionString,
CommandType commandType, string commandText, params OleDbParameter[]
commandParameters)
{
//create & open an OleDbConnection, and dispose of it after we are
done.
using (OleDbConnection cn = new OleDbConnection(connectionString))
{
cn.Open();

//call the overload that takes a connection in place of the
connection string
return ExecuteDataset(cn, commandType, commandText,
commandParameters);
}
}

 

[Cowboy \(Gregory A. Beamer\)]

Go through and call Dispose on connections when finished with them. Profile
the connections in Oracle and ensure they are being closed (I have seen
instances where this is not true and it is not good). You should also ensure
the connections are used for as short a time as possible.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************

 

[John G]

Thanks Cowboy. Should I also make the connection = null;

Go through and call Dispose on connections when finished with them. Profile
the connections in Oracle and ensure they are being closed (I have seen
instances where this is not true and it is not good). You should also ensure
the connections are used for as short a time as possible.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************

I have been using the OleBDhelper
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/daab.asp)
with oracle. With a small group of people we recieved the following
message:
ORA-00020: maximum number of processes (%s) exceeded


Looking at some of the code in the OledbHelper, I noticed that there
was no close method on the connection. Can this be it. Also, I saw from
another user was they also set the connection to null so the garbage
collection would clean up that connection. thanks in advance.
Code:

public static DataSet ExecuteDataset(string connectionString,
CommandType commandType, string commandText, params OleDbParameter[]
commandParameters)
{
//create & open an OleDbConnection, and dispose of it after we are
done.
using (OleDbConnection cn = new OleDbConnection(connectionString))
{
cn.Open();

//call the overload that takes a connection in place of the
connection string
return ExecuteDataset(cn, commandType, commandText,
commandParameters);
}
}