Error in New DataSource ???

[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

[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.