I will never understand the need for a unique key for IBMs ODBC driver to
work. Given a sql statement of

update item set price = price * 1.1 where class = 'ABC'

Maybe someone can explain why in the world you'd need a unique key to do
this? Or even

Update item set price = 1.3 where itemno = 12345

Itemno may be unique, but then again maybe not, why does IBM's ODBC driver


Walden H Leverich III
Tech Software
(516)627-3800 x11

-----Original Message-----
From: Mike Naughton [mailto:mnaughton@juddwire.com]
Sent: Thursday, December 27, 2001 12:24
To: web400@midrange.com
Cc: midrange-l@midrange.com; web400@midrange.com
Subject: Re: [WEB400] Client Access ODBC Driver error

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

This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To post a
message email: WEB400@midrange.com To subscribe, unsubscribe, or change list
visit: http://lists.midrange.com/cgi-bin/listinfo/web400
or email: WEB400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

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.