Hi Sushama,

If this just started happening, these suggestions may not be helpful, but
just in case:

1) verify that your ODBC connection allows updates
2) verify that this connection specifies a file on the AS/400 that has a
unique key (I've been bitten by this one more than once! ;-)
3) test another update to see if the problem is just with this statement
or if it is more general . . .

Good luck,

web400@midrange.com writes:
>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
>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
>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.

Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444

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