IBM DB2 UDB 2005 Reporting Services

[steveschoonover]

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????

[johnscritpts]

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 ?

[Bwill]

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.