RE: Client Access ODBC Driver error

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
care?

-Walden


------------
Walden H Leverich III
President
Tech Software
(516)627-3800 x11
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com



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


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

_______________________________________________
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
options,
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.