Hi Folks,
I have a table module that I developed to handle the MS GridView. I seem to be having a timeout problem with it. This is a fairly complex GridView implementation because it actually contains a main GridView with another embedded one. I am using the MS ObjectDataSource object and calling methods that use the DNN data provider. Here is a typical statement:
Return CType(SqlHelper.ExecuteReader(AltDBConnectionString, GetFullyQualifiedName("GetPgMembers"), sortExpression, startRowIndex, maximumRows, searchArg, typeArg, Msg), IDataReader)
I am also using ExecuteScalar and ExecuteNonQuery. I am not using ExecuteSQL.
Here is the first part of the error message:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: 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…
Could this be a connection closing issue? I am not explicitly closing any connections. Should I be doing that? I was under the impression that DNN handles that. Does anyone have some experience with implementing the GridView component in DNN? Am I possibly running afoul of special issues with GridView and DNN? Anything that points me in the right direction would be most appreciated.
Thanks,
G. M.