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.