Hello,

I'm using next code for reading data from database:

Using myIDataReader As IDataReader = CType(DataProvider.Instance().ExecuteSQL("SELECT ItemsID FROM {databaseOwner}{objectQualifier}SomeItems WHERE ItemsCode = @ItemsCode AND FirmID = @FirmID", ItemsCodeParam, FirmIDParam), IDataReader)
            myIDataReader.Read()

            intItemsID = myIDataReader.GetInt32(0)
        End Using

and it all worked fine until this error:

Error   Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

I thought I closed sql connection with "using". Am I wrong? I chaged max pool size and it work little longer, until crash. After that I set "pooling=false", but that is not right solution.  I forgot to mention I'm using AJAX, if that is relevant for this problem...

Thanks

Hi,

thanks for reply...

Does myIDataReader.Close()  also close sql connection?

What about ExecuteReader or ExecuteScalar?