RE: VB5 and Informix

Mike That problem exist because the connection from windows to the Unix server have been terminated. It usually happen if you bring down the Informix instance on Unix side. You are right that the only solution is to disconnect and then reconnect. Van Pham Engineering Lucent Technologies > ---------- > From: Michael O'Sullivan[SMTP:MichaelOS@peregrine.ie] > Reply To: Michael O'Sullivan > Sent: Friday, October 22, 1999 4:19 AM > To: informix-list@iiug.org > Subject: VB5 and Informix > > Hi folks, > > I have an intermittent problem when either trying to insert , update or > delete from and Informix database in Vb5.> > When the problem does occur I get a total crash with a Dr. Watson file > being > generated or sometimes error 28 (out of stack space) and then the crash. I > have checked the stack using the stack viewer and all I see is two funtion > calls. I use the following syntax to insert, update or delete: > > Db.Execute SQLQ, dbSqlPassThrough > > where SQLQ is the sql string. > > Sometimes the above statement works fine and the relevant action has taken > place in the database. > > The only solution I have found so far is to disconnect and then reconnect > to > the database before the action. > > Has anyone else got other ideas? > > Regards, > Michael. > >