View Single Post
  #1 (permalink)  
Old April 30th, 2008, 02:05 AM
zaheerabbas.sk zaheerabbas.sk is offline
Authorized User
 
Join Date: Jun 2006
Location: Hyderabad, Andhrapradesh, India.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.