SSRS 2005 calling stored procedure in Informix with parameters

Posted on 2011-09-29
Medium Priority
Last Modified: 2013-12-28
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
Question by:rbaskett
  • 2
  • 2
LVL 25

Expert Comment

ID: 36861199
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.

Author Comment

ID: 36863455
yes, the statement executes directly in Informix by several users including the one defined in the ODBC DSN.
LVL 25

Accepted Solution

TempDBA earned 2000 total points
ID: 36863627
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.

Author Comment

ID: 36867298
fully qualified database+owner+sproc name worked - thanks!

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

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.

Join & Write a Comment

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question