SSRS 2005 calling stored procedure in Informix with parameters
Posted on 2011-09-29
Im trying to call a stored procedure from within SSRS 2005 that lives in Informix. I can retrieve data from tables, but when I attempt to create a dataset of type "stored procedure" SSRS does not recognize the procedures in my informix database. The procedures are not in the drop down box. If I try to create a Text command type and enter in the statement execute procedure root.bobs(1, 'RFR', 'CRTEST'), SSRS will not parse the statement stating that the "routine (root.bobs) cannot be resolved". I have granted execute on the procedure to public, the user defined in the ODBC driver has permissions to execute it.
using 32 bit Informix Driver from CSDK 3.7 on Windows 7