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

I have been using the OleBDhelper
(http://msdn.microsoft.com/library/d...2/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);
}
}

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" <jwgiblin3@hotmail.com> wrote in message
news:1158351673.592815.126750@m73g2000cwd.googlegroups.com...
>I have been using the OleBDhelper
> (http://msdn.microsoft.com/library/d...2/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);
> }
> }
>

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

Cowboy (Gregory A. Beamer) wrote:
> 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" <jwgiblin3@hotmail.com> wrote in message
> news:1158351673.592815.126750@m73g2000cwd.googlegroups.com...
> >I have been using the OleBDhelper
> > (http://msdn.microsoft.com/library/d...2/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);
> > }
> > }
> >