Maximum number of cursors exceeded.
Hi,
I have written a windows service,in which Im using cursors to fetch data from the tables into a dataset.The service is giving an exception "Max number of open cursors exceeded", i have disposed, the connection object,command object, but the problem still exists. I have another idea of using GC.collect(),but it is degrading my service's performance. Any other solution would be appreciated.
Intellectuals solve problems but Genious avoid problems.
__________________
Intellectuals solve problems but Genious avoid problems.
|
