Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Executing DB2 Stored Procedures from MS-Reporting Services

Status
Not open for further replies.

micha123

Programmer
Jul 5, 2005
189
CA
I am trying to execute DB2 UDB Stored Procedures directly from Reporting Services.
The DB2 is on AS/400.

I've tried to run this with the following providers:
* Microsoft ODBC for DB2
* Microsoft OLE DB Provider for DB2
* IBM ODBC for DB2
* ODBC and OLEDB for iSeries

When I am running DB2 UDB on WIN/XP - I can call Stored Procedures with no problem with Reporting Services 2005 and "Microsoft OLE DB Provider for DB2" (I had to install SQL SERVER 2005 Developer Edition on the same machine).
The exact same thing is not working with the DB2 on the AS/400. I am getting the following error:
"Failed to convert parameter value from String to a Byte[]".
The SP parameter is string.

Does anyone knows which Provider I can use for that matter?

Thanks,
M.


"A long life is when each day is full and every hour wide!"
(A Jewish Mentor)
M. [hourglass]

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top