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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


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

Browse other questions tagged or ask your own question.