Page 1 of 1

Error in New DataSource ???

Posted: Fri May 11, 2007 7:05 am
by jayakumargr
Hi,

I wrote a stored procedure which accepts 2 parameters. using that procedure i create a table "category".

In stiReport2007.1 ,i create a sql connection and add a new data source with data from sql connection(select type of data).In that i wrote following statements,

EXEC STP_NAME 1003,'0'

select * from Category

It Executes sucessfully.
While Retriving, it shows following error!!

Maximum stored procedure,function,trigger,or view nesting level exceeded(limit 32)

How to solve this error...??


Thanks in advance,
Jayakumar

Error in New DataSource ???

Posted: Fri May 11, 2007 8:17 am
by Vital
Unfortunately, we can't solve this problem because we simply redirect your queries to ado.net. I hope following link can help you:
http://download.microsoft.com/download/ ... AA68F848E5

Please see topic: Topic: Error message: "Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)"

Thank you.