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