Oninit cdi / Archive
Talk to an expert →

ESQL-C with Redhat ES 3 and IDS 9.40UC4

Posted in 2004

Topics: Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Versions, Editions & End-of-Life

John Fahey — — source: IIUG Forums & Mailing Lists

----- Original Message ----- From: John Fahey To: classics@iiug.org ; ids@iiug.org ; linux-informix@iiug.org Sent: Friday, November 19, 2004 2:37 PM Subject: ESQL-C with RH ES and IDS9.40UC4 Hi list(s) - We have a new installation of the above - Got the new ESQL-C specifically for RH ES : esql -V output: IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.UC3 Sporadically (more often than not) any ESQL-C programs we run fail at the database declaration line with a 25588 error. The database otherwise (as far as we know) is completely functional: Our screens (FourJS) as well as any dbaccess we do work fine. When the ESQL-C programs do start, they run through fine with no other errors. No complaints in online.log ... HELP HELP!! Thanks in advance. John Fahey jfahey@mandm.net jjfahey@gmail.com -- John Fahey Mitchell & McCormick, Inc. 2165 West Park Ct Suite G Stone Mountain, GA 30087 (770) 465-1511

↪ replying to John Fahey
Andrew Lennard — — source: IIUG Forums & Mailing Lists

No solution I'm afraid, but... Is this the first time you try to communicate with a database? Have you tried catching the error and looping back to try again? using sqlexit() to break the connection and start again... What about not using the shared-memory connection? May not solve the problem, but might get you out of a hole... Does the code pass cleanly through something like Purify and not leak or access free-d memory, etc? Hope you get a solution, ANdy. >From: "John Fahey " <jjfahey@gmail.com> >To: ids@iiug.org >Subject: ESQL-C with Redhat ES 3 and IDS 9.40UC4 [3732] Date: Fri, 19 Nov >2004 15:21:49 -0500 (EST) > >----- Original Message ----- >From: John Fahey >To: classics@iiug.org ; ids@iiug.org ; linux-informix@iiug.org >Sent: Friday, November 19, 2004 2:37 PM >Subject: ESQL-C with RH ES and IDS9.40UC4 > > >Hi list(s) - > >We have a new installation of the above - Got the new ESQL-C specifically >for >RH ES : > >esql -V output: > >IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.UC3 > >Sporadically (more often than not) any ESQL-C programs we run fail at the >database declaration line with a 25588 error. The database otherwise (as >far as we know) is completely functional: Our screens (FourJS) as well as >any dbaccess we do work fine. When the ESQL-C programs do start, they run >through fine with no other errors. No complaints in online.log ... > >HELP HELP!! > >Thanks in advance. > >John Fahey >jfahey@mandm.net >jjfahey@gmail.com > >-- >John Fahey > >Mitchell & McCormick, Inc. >2165 West Park Ct Suite G >Stone Mountain, GA 30087 >(770) 465-1511 > _________________________________________________________________ Use MSN Messenger to send music and pics to your friends http://www.msn.co.uk/messenger

↪ replying to John Fahey
John Fahey — — source: IIUG Forums & Mailing Lists

Tried eschewing shared memory, no change. I can reduce the code down to just the database declare and it (mis)behaves the same way. It is possible to loop through the error and make it eventually work, but it takes about 12 seconds to fail each time, plus that's a bit too ugly for my liking! This same code runs (and has run for many years) on platforms as diverse as SCO OpenServer with IDS 9.21, and AIX 5.xx with 5.0 SE ... I'm wondering if it's some /usr/lib based library difference / mismatch ... Thanks! John Fahey jjfahey@gmail.com jfahey@mandm.net On Sat, 20 Nov 2004 20:45:18 +0000, Andrew Lennard <andy_lennard@hotmail.com> wrote: > No solution I'm afraid, but... > > Is this the first time you try to communicate with a database? > > Have you tried catching the error and looping back to try again? using > sqlexit() to break the connection and start again... > > What about not using the shared-memory connection? May not solve the > problem, but might get you out of a hole... > > Does the code pass cleanly through something like Purify and not leak or > access free-d memory, etc? > > Hope you get a solution, > ANdy. > > >From: "John Fahey " <jjfahey@gmail.com> > >To: ids@iiug.org > >Subject: ESQL-C with Redhat ES 3 and IDS 9.40UC4 [3732] Date: Fri, 19 Nov > >2004 15:21:49 -0500 (EST) > > > > > >----- Original Message ----- > >From: John Fahey > >To: classics@iiug.org ; ids@iiug.org ; linux-informix@iiug.org > >Sent: Friday, November 19, 2004 2:37 PM > >Subject: ESQL-C with RH ES and IDS9.40UC4 > > > > > >Hi list(s) - > > > >We have a new installation of the above - Got the new ESQL-C specifically > >for > >RH ES : > > > >esql -V output: > > > >IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.UC3 > > > >Sporadically (more often than not) any ESQL-C programs we run fail at the > >database declaration line with a 25588 error. The database otherwise (as > >far as we know) is completely functional: Our screens (FourJS) as well as > >any dbaccess we do work fine. When the ESQL-C programs do start, they run > >through fine with no other errors. No complaints in online.log ... > > > >HELP HELP!! > > > >Thanks in advance. > > > >John Fahey > >jfahey@mandm.net > >jjfahey@gmail.com > > > >-- > >John Fahey > > > >Mitchell & McCormick, Inc. > >2165 West Park Ct Suite G > >Stone Mountain, GA 30087 > >(770) 465-1511 > > > > _________________________________________________________________ > Use MSN Messenger to send music and pics to your friends > http://www.msn.co.uk/messenger > > -- John Fahey President Mitchell & McCormick, Inc. 2165 West Park Ct Suite G Stone Mountain, GA 30087 (770) 465-1511

Glossary