Quote:
Originally Posted by 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????
Hey Mi name is John, so I have the same problem. Could you show me how to the c# program solve this problem ?
