Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

In SSRS, when I pass hard-coded values to my stored procedure, it works fine. But it doesn't work when I try to pass the parameters.

Can you please tell me the right syntax for calling MySQL stored procedures in SSRS, through an ODBC datasource?

share|improve this question
1  
The word is "please". –  Phil May 4 '13 at 11:05
    
Hi Phil, Actuaaly my problem is either SSRS or the ODBC driver is having a problem sending/receiving the parameter value. Other attempts at syntax: call shop.GetRegions() , call shop.GetRegions(?) , call shop.GetRegions(regid), call shop.GetRegions(@regid) None of these worked. If I call the procedure with a hard coded value i.e. call shop.GetRegions(5) - it works. Again, if the stored procedure has no parameters it works fine. I Want to know How to call mysql stored procedure in SSRS Reporting? Can You give me any real direction on this issue. –  Samba May 4 '13 at 11:24
    
Hi Samba, please edit your question to add the additional information. Make sure you format the code correctly (there's help/information in the editor toolbar for that). (What Phil meant is that you should not use abbreviations or "text speak" in your posts here. Please use complete words and sentences.) –  Mat May 4 '13 at 11:51

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.