PDA

Click to See Complete Forum and Search --> : Can oledb open more than 250 Command Objects at a same time?

Kevin Huang
April 21st, 1999, 03:55 AM
I got error when I try the prepare the 251st command object. Is there any way to break the limitation?
Kevin Huang
April 23rd, 1999, 01:15 AM
When I use ODBC data source, if the CCommand objects call the stored procedures that return value but not return Rowset, the limitation is not exist. When call the stored procedures that return Rowset, the limitation show up (and the error is about SQL, cursor not exist).
When I use SQL native oledb data source, with set proper property, I can call the stored procedures that return Rowset without limitation.
That's what I found till now. I am still trying. If anyone has similar experience and solution, I'll be very grateful.