Oninit cdi / Archive
Talk to an expert →

isql 7.50.uc1 strange behavior

Posted in 2009

Topics: Installation, Setup & Upgrades, Server Administration, Platform-Specific Issues

Peter_Logan@spartanstores.com — — source: IIUG Forums & Mailing Lists

WE have just installed the above version of isql on an AIX 5.1 system ... with a v11.50.fc5 engine ... When isql is run ... it's not showing a list of the sql and forms or reports that have been created ... you can type them into the selection box, and they come up ... This was working fine with isql 7.32uc3 ... Anyone have any suggestions where to look ? dbaccess will bring up the list of sql scripts ... so I think it's just an isql thing ... Thanks in advance ... Peter Logan Senior Database Administrator Phone: 616/878-8309

↪ replying to Peter_Logan@spartanstores.com
MONTEVERDE Olmedo — — source: IIUG Forums & Mailing Lists

Hi Peter, If you were able to install V11.50 on AIX 5.1, that's probably the problem : http://www-01.ibm.com/software/data/informix/ids/requirements/aix.html Accordingly to that link, you need at least AIX 7.3 HTH, Olmedo Monteverde 1701 Fribourg, Switzerland -----Message d'origine----- De : ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] De la part de Peter_Logan@spartanstores.com Envoyé : lundi, 5. octobre 2009 15:08 À : ids@iiug.org Objet : isql 7.50.uc1 strange behavior [17323] WE have just installed the above version of isql on an AIX 5.1 system ... with a v11.50.fc5 engine ... When isql is run ... it's not showing a list of the sql and forms or reports that have been created ... you can type them into the selection box, and they come up ... This was working fine with isql 7.32uc3 ... Anyone have any suggestions where to look ? dbaccess will bring up the list of sql scripts ... so I think it's just an isql thing ... Thanks in advance ... Peter Logan Senior Database Administrator Phone: 616/878-8309 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to MONTEVERDE Olmedo
MONTEVERDE Olmedo — — source: IIUG Forums & Mailing Lists

Sorry, I meant AIX 5.3 Olmedo Monteverde 1701 Fribourg, Switzerland -----Message d'origine----- De : ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] De la part de MONTEVERDE Olmedo Envoyé : lundi, 5. octobre 2009 18:13 À : ids@iiug.org Objet : RE: isql 7.50.uc1 strange behavior [17335] Hi Peter, If you were able to install V11.50 on AIX 5.1, that's probably the problem : http://www-01.ibm.com/software/data/informix/ids/requirements/aix.html Accordingly to that link, you need at least AIX 7.3 HTH, Olmedo Monteverde 1701 Fribourg, Switzerland -----Message d'origine----- De : ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] De la part de Peter_Logan@spartanstores.com Envoyé : lundi, 5. octobre 2009 15:08 À : ids@iiug.org Objet : isql 7.50.uc1 strange behavior [17323] WE have just installed the above version of isql on an AIX 5.1 system ... with a v11.50.fc5 engine ... When isql is run ... it's not showing a list of the sql and forms or reports that have been created ... you can type them into the selection box, and they come up ... This was working fine with isql 7.32uc3 ... Anyone have any suggestions where to look ? dbaccess will bring up the list of sql scripts ... so I think it's just an isql thing ... Thanks in advance ... Peter Logan Senior Database Administrator Phone: 616/878-8309 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Peter_Logan@spartanstores.com
gerd kaluzinski — — source: IIUG Forums & Mailing Lists

That's a known problem related to C-SDK 3.50.xC5. just install a different version of C-SDK as for example 3.50.xC4 or even 3.00 and set LD_LIBRARY_PATH to the esql-lib of that version instewad of th xC5. After that, you will see all Forms and Reports as in former versions. Best regards, Gerd > WE have just installed the above version of isql on an AIX 5.1 system ... > with a v11.50.fc5 engine ... When isql is run ... it's not showing a list > of the sql and forms or reports that have been created ... you can type > them into the selection box, and they come up ... This was working fine > with isql 7.32uc3 ... Anyone have any suggestions where to look ? > dbaccess will bring up the list of sql scripts ... so I think it's just an > isql thing ... > > Thanks in advance ... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ________________________________________________________________ Neu: WEB.DE Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate für nur 19,99 Euro/mtl.!* http://produkte.web.de/go/02/

↪ replying to gerd kaluzinski
Peter_Logan@spartanstores.com — — source: IIUG Forums & Mailing Lists

Thanks ... I found that out a little bit ago .... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "gerd kaluzinski" <gerd.kaluzinski@web.de> To: ids@iiug.org Date: 10/05/2009 12:56 PM Subject: Re: isql 7.50.uc1 strange behavior [17338] Sent by: ids-bounces@iiug.org That's a known problem related to C-SDK 3.50.xC5. just install a different version of C-SDK as for example 3.50.xC4 or even 3.00 and set LD_LIBRARY_PATH to the esql-lib of that version instewad of th xC5. After that, you will see all Forms and Reports as in former versions. Best regards, Gerd > WE have just installed the above version of isql on an AIX 5.1 system ... > with a v11.50.fc5 engine ... When isql is run ... it's not showing a list > of the sql and forms or reports that have been created ... you can type > them into the selection box, and they come up ... This was working fine > with isql 7.32uc3 ... Anyone have any suggestions where to look ? > dbaccess will bring up the list of sql scripts ... so I think it's just an > isql thing ... > > Thanks in advance ... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ________________________________________________________________ Neu: WEB.DE Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate für nur 19,99 Euro/mtl.!* http://produkte.web.de/go/02/ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary