Solved

SSRS 2005 calling stored procedure in Informix with parameters

Posted on 2011-09-29
4
972 Views
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
0
Comment
Question by:rbaskett
  • 2
  • 2
4 Comments
 
LVL 25

Expert Comment

by:TempDBA
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.
0
 

Author Comment

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

Accepted Solution

by:
TempDBA earned 500 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.
0
 

Author Comment

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

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Visual Studio 2008 book recommendation 6 37
CREATE DATABASE ENCRYPTION KEY 1 59
aix unix tar error 3 43
SSRS Dynamic Column Names - Last 8 Weeks 3 17
Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

861 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now