RE: Strange Informix Error messages

You said ODBC, so assuming you're using ADO, inspect the errors collection of the connection object. This collection usually contains the Informix error messages. Then run finderr to see the text. -----Original Message----- From: mars1972@my-deja.com [mailto:mars1972@my-deja.com] Sent: Friday, July 14, 2000 2:06 PM To: informix-list@iiug.org Subject: Re: Strange Informix Error messages You need to find out what the ISAM error code is to fix the problem. This error code is in the sqlca structure, in sqlerrd[1]. I'm not sure how you would reference it using ODBC, I would think you could do a dbinfo(sqlca.sqlerrd1), but I'm not sure. It looks like someone may have an exclusive lock on the table. In article <396f2b39$1_3@corp.newsfeeds.com>, "Nick Palmer" <nick@kcicorp.com> wrote: > Hi all, > > Hopefully someone here can shed some light on some problems we are having. > We are using IDS 7.31 on an HP box (HP/UX 10.20 I believe) and running a > client/server app using the Informix ODBC drivers. Sometimes when we are > using our app, we get the following errors: > > -240 Could not delete a row. > > -243 Could not position within a table table-name. > > -244 Could not do a physical-order read to fetch next row. > > If we perform the same operation again, the error will not come back. The > Informix error guides isn't to helpfull in explaining exactly what the > problem is, except to say that its an ISAM problem. Is there something I > can configure on the server, or maybe in the ODBC driver that would make > these problems go away. Any help would be gratefully appreciated. > > Thanks in advance. > Nick > (nick@kcicorp.com) > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =----- > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy. ------------------------------------------------------------------------------------------------------------ This e-mail is sent by a law firm and may contain information that is privileged or confidential. If you are not the intended recipient, please delete the e-mail and any attachments and notify us immediately.