By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

IBM DB2 UDB 2005 Reporting Services

P: 1
I wrote a SQL Stored procedure on the Iseries (AS400) V5R4 in Iseries Navigator and I am trying to call it from 2005 SQL Reporting Services and I am trying to use the OLE DB managed provider from IBM Client Access V5R4 "IBMDA400 OLE DB Provider" to make the connection inside reporting services. When I test the connection, it is OK, but when I test the call to the Stored procedure when creating the data set, I get an error "Object Reference not set to instance of an object". I tried the same thing with an ODBC driver and it worked fine. I even wrote a C# program and used the "IBMDA400 OLE DB Provider" to call the stored procedure and it worked fine. It seems that Reporting services has a problem with the driver. Has anyone figured out to make this work????
Oct 9 '07 #1
Share this Question
Share on Google+
2 Replies


P: 1
I wrote a SQL Stored procedure on the Iseries (AS400) V5R4 in Iseries Navigator and I am trying to call it from 2005 SQL Reporting Services and I am trying to use the OLE DB managed provider from IBM Client Access V5R4 "IBMDA400 OLE DB Provider" to make the connection inside reporting services. When I test the connection, it is OK, but when I test the call to the Stored procedure when creating the data set, I get an error "Object Reference not set to instance of an object". I tried the same thing with an ODBC driver and it worked fine. I even wrote a C# program and used the "IBMDA400 OLE DB Provider" to call the stored procedure and it worked fine. It seems that Reporting services has a problem with the driver. Has anyone figured out to make this work????
Hey Mi name is John, so I have the same problem. Could you show me how to the c# program solve this problem ?
Feb 27 '08 #2

P: 1
Assuming you can connect to your ISeries, set up your data set and use Text for the command type. Then, enclose your query string in curly braces:

{call lib.object(parm)} Use ? for the parms and seperate mult parms by a comma.

In my case I had one parameter: {call RT_DB.RPT_HHQVOL(?)}

Works like a champ.
Apr 23 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.