User Profile

pkoeppe · Dec 14 '07, 07:47 AM

Does nobody have an idea?

That's the way I do my requests now, but also there is the problem that for each request a new real connection is opened and not really closed. My DBA says there are x connections after x requests. How can I avoid this? How can I clear the connection to the DB really???

Code:

public DataTable Request()
{
  try
  {
    using (OleDbConnection connection = new OleDbConnection(Constants.DB2_CONNECTION_STRING))

...

pkoeppe · Dec 12 '07, 01:36 PM

But why it works in the first 8 minutes? In the first 8 minutes I also send requests and it works, after 8 minutes (the request is 100% the same) I get the error. Why???

For a work around I open a new connection for each request and close the connection after the request. But here the connection seems not to be closed really. The connection state is closed but the database says there is still a connection. After some request I get...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Problem with DB2