This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
[ Picked text/plain from multipart/alternative ]
Hi All,

I am getting this error when I try do an SQL UPDATE on a table via ASP :

"-2147467259[Microsoft OLE DB Provider for ODBC Drivers]: [IBM][Client
Access ODBC Driver (32-bit)][DB2/400 SQL]SQL7008 - PDBACCTREF in DBTEST not
valid for operation."

I can do a SELECT but it fails when I try to do an UPDATE. We recently
upgraded to V5R1. I have started getting this error since then.

I read somewhere that the file need to be journaled so I have setup
journaling, but it did not help.

Client access service pack level is in sync with the AS400 level.

Someone on this list suggested there was fix for the CWBODBC.DLL available
and I tried to install that but that gave me more trouble, would not let me
even connect to the database :

"429[Microsoft VBScript runtime error]:  ActiveX component can't create
Failed to connect to the database"

Any and all help will greatly appreciated.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.