SSRS 2005 calling stored procedure in Informix with parameters

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
rbaskettAsked:
Who is Participating?
 
TempDBAConnect With a Mentor Commented:
and if you are calling the procedure from some other database where the stored procedure doesn't resides, how you do it. Please try the same statement in the reporting service too.
0
 
TempDBACommented:
I had never got a chance with working on informix, but the call should be more or less same.
Is the execute procedure statement working in the database. If so, which should be (so you have mentioned here), can you check for the full naming convention.
Like in sql server if you doesn't give schema name i.e. exec dbo.procedurename, it sometimes finds problem in searching it.
0
 
rbaskettAuthor Commented:
yes, the statement executes directly in Informix by several users including the one defined in the ODBC DSN.
0
 
rbaskettAuthor Commented:
fully qualified database+owner+sproc name worked - thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.