[unixODBC-dev] Re: ODBCConfig question
nick at lurcher.org
Wed Sep 28 13:43:45 BST 2005
anand.vasudevan at wipro.com wrote:
> Our application tries to connect to different Ingres databases.
> We get the foll. error: -
> "[unixODBC][CA][Ingres ODBC Driver][Ingres]GCC server has exceeded max
> inbound connections."
> when our application connects to different databases roughly (15 to 20)
> in a sequential manner.
> A typical scenario is
> 1. Connect to the database
> 2. Perform necessary insert/delete/update
> 3. Disconnect
> The application checks to see if the database is already connected by
> comparing the name of the previously connected database in a C structure
> and if it does not match then it calls SQLDisconnect.
> After all the table operations are done, it disconnects by calling
> Should it call SQLFreeHandle(SQL_HANDLE_CON) each time it wants to
> release the connection completely.
> Will Connection Pooling help solve the problem? If yes, then should it
> be of type 'SQL_CP_ONE_PER_DRIVER' or 'SQL_CP_ONE_PER_HENV'?
You need to look at what is causing the problem before using pooling.
I would turn on ODBC tracing and check that you are disconnecting.
Also its entirly down to the driver if it actually disconnects.
More information about the unixODBC-dev