I got error when I try the prepare the 251st command object. Is there any way to break the limitation?
Printable View
I got error when I try the prepare the 251st command object. Is there any way to break the limitation?
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.