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:email@example.com] Sent: Thursday, December 27, 2001 12:24 To: firstname.lastname@example.org Cc: email@example.com; firstname.lastname@example.org 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, email@example.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 firstname.lastname@example.org _______________________________________________ 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: WEB400email@example.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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.