Problems with AS/400 Access

[bburnell]

Hi all. Recently we did an upgrade on our AS/400 from an 820 to 520 model, as well as an OS change from v5.1 to v5.3. After this upgrade we are getting the following error in asp (w/ vb6 dll using odbc):

COM Error Number -2147217913 (0x80040E07)
File Name /V221/Reports/ReportShow.asp
Line Number 149
Brief Description ErrSrc:ktwdal.cData.GetCommandData - ErrDesc:ErrSrc:Microsoft OLE DB Provider for ODBC Drivers - ErrDesc:[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0304 - Conversion error in assignment to host variable *N.
Browser Version Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)

"SQL0304 SQLCODE -304 SQLSTATE 22003, 22023, 22504
Explanation: Conversion error in assignment to host variable &2."

I am using asp on a Windows 2000 Server as well as VB6 sp 6 (for the class calling the AS/400 stored procedure through a system odbc connection) and Crystal v8.5. All the other reports seem to work fine. Any help would be greatly appreciated. Thanks!
Brett

--------------------------
Please visit my website!

http://www.smsforce.com

 

[bburnell]

Hi all,
This has been resolved as an AS/400 RPG error. The recordset was being tied to the same job number and was returning jumbled data the second time around.
Thanks!
Brett