isql run error after upgrade
After upgrading IDS from 11.50.FC3 to FC5, ISQL 7.32 no longer listed *.per form source files in the form compile menu. Suggestions included checking DBPATH/current directory and file permissions, but these didn't help. Manoj identified it as a known CSDK defect (IBM APAR IC62803): the server install ships a newer CSDK that overwrites libraries used by ISQL/4GL. The poster confirmed that deselecting client-SDK during the IDS install avoided the problem; Art suggested installing ISQL separately with its own LD_LIBRARY_PATH or moving to ISQL 7.50. No official fix was available in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
isql version : 7.32fc2 ids version: 11.5FC3 upgrade to 11.5FC5 After upgarading to 11.5fc5. Running isql select form -> compile . It will not list all the *.per source file. isql version not change. Install steps: 1. create a new directory 2. install isql 3. install ids Anyone can help me?
joe wrote: > isql version : 7.32fc2 > ids version: 11.5FC3 upgrade to 11.5FC5 > After upgarading to 11.5fc5. > Running isql > select form -> compile . > It will not list all the *.per source file. > > isql version not change. > Install steps: > 1. create a new directory > 2. install isql > 3. install ids > Anyone can help me? You should always install your tools in a separate directory to the engine. I suspect some library file has been overwritten somewhere. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
CSDK defect. http://www.informixmag.com/content/view/19795/27/ -Manoj From: joe <joeclhua@gmail.com> To: informix-list@iiug.org Date: 12/30/2009 04:11 PM Subject: isql run error after upgrade Sent by: informix-list-bounces@iiug.org isql version : 7.32fc2 ids version: 11.5FC3 upgrade to 11.5FC5 After upgarading to 11.5fc5. Running isql select form -> compile . It will not list all the *.per source file. isql version not change. Install steps: 1. create a new directory 2. install isql 3. install ids Anyone can help me? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
Manoj Vakeel wrote: > > CSDK defect. > > http://www.informixmag.com/content/view/19795/27/ > > -Manoj > > > > From: joe <joeclhua@gmail.com> > To: informix-list@iiug.org > Date: 12/30/2009 04:11 PM > Subject: isql run error after upgrade > Sent by: informix-list-bounces@iiug.org > > > ------------------------------------------------------------------------ > > > > isql version : 7.32fc2 > ids version: 11.5FC3 upgrade to 11.5FC5 > After upgarading to 11.5fc5. > Running isql > select form -> compile . > It will not list all the *.per source file. > > isql version not change. > Install steps: > 1. create a new directory > 2. install isql > 3. install ids > Anyone can help me? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > That link tells you very little unless you have the appropriate access rights to follow the further link to http://www.ibm.com/support/docview.wss?rs=681&context=SSVT2J&dc=DB550&uid=swg1IC62803&loc=en_US&cs=UTF-8&lang=en&rss=ct681db2 Is there a workround? -- Ian The Hotmail address is my spam-bin. Real mail address is iang at austonley org uk
Make sure that the directory containing the form files in in the DBPATH environment variable. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Dec 30, 2009 at 5:06 PM, joe <joeclhua@gmail.com> wrote: > isql version : 7.32fc2 > ids version: 11.5FC3 upgrade to 11.5FC5 > After upgarading to 11.5fc5. > Running isql > select form -> compile . > It will not list all the *.per source file. > > isql version not change. > Install steps: > 1. create a new directory > 2. install isql > 3. install ids > Anyone can help me? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >
Thanks for all you guy's help, After install isql & then intalling ids 11.5FC5 . If I deselect client-sdk , It will be OK! So I think that it must be somefiles overwritten by client-sdk .
Art Kagel wrote: > Make sure that the directory containing the form files in in the DBPATH > environment variable. > > Art > > Art S. Kagel > Oninit (www.oninit.com <http://www.oninit.com>) > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org>) > > See you at the 2010 IIUG Informix Conference > April 25-28, 2010 > Overland Park (Kansas City), KS > www.iiug.org/conf <http://www.iiug.org/conf>; > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Oninit, the IIUG, nor any other > organization with which I am associated either explicitly or implicitly. > Neither do those opinions reflect those of other individuals affiliated > with any entity with which I am affiliated nor those of the entities > themselves. > > > > On Wed, Dec 30, 2009 at 5:06 PM, joe <joeclhua@gmail.com > <mailto:joeclhua@gmail.com>> wrote: > > isql version : 7.32fc2 > ids version: 11.5FC3 upgrade to 11.5FC5 > After upgarading to 11.5fc5. > Running isql > select form -> compile . > It will not list all the *.per source file. > > isql version not change. > Install steps: > 1. create a new directory > 2. install isql > 3. install ids > Anyone can help me? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org <mailto:Informix-list@iiug.org> > http://www.iiug.org/mailman/listinfo/informix-list > > Art, Manoj's response points to the problem. The server install also installs a new version of the CSDK which tramples on several libraries used by ISQL & 4GL. It doesn't matter where DBPATH points, the older stuff is broken. There's no indication I've seen as to how to fix it. Would reinstalling ISQL break the CSDK? Can the CSDK be deinstalled & replaced with an older one? If so which is recommended? Is there a fixed version of the CSDK available? I can't see Obo's solution of installing in different directories helping - whatever library path is set to it's bound to resolve to one set of libraries or the other and unless the CSDK will work with the older libraries one or other of the toolsets is going to end up using the wrong libraries. I'd noticed the problem on my own Linux laptop a few days ago but not got round to investigating it. In fact I'd assumed it was probably yet another non-backward-compatible Linux upgrade until this thread appeared but in fact it must have been the CSDK I installed earlier. -- Ian The Hotmail address is my spam-bin. Real mail address is iang at austonley org uk
Yeah. Sounds that way. Joe, it sounds like you can either install ISQL in
a separate directory listing the lib subdirectory of that installation first
in LD_LIBRARY_PATH for running ISQL apps and the lib subdirectory of the IDS
installation first for running other Informix applications such as dbaccess
and the on* tools or you could try getting an upgrade to ISQL v 7.50 which
is probably compatible with the libraries included with the CSDK 3.50
release that comes with IDS 11.50.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Thu, Dec 31, 2009 at 6:02 AM, Ian Goddard <goddai01@hotmail.co.uk> wrote:
> Art Kagel wrote:
> > Make sure that the directory containing the form files in in the DBPATH
> > environment variable.
> >
> > Art
> >
> > Art S. Kagel
> > Oninit (www.oninit.com <http://www.oninit.com>)
> > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org>)
> >
> > See you at the 2010 IIUG Informix Conference
> > April 25-28, 2010
> > Overland Park (Kansas City), KS
> > www.iiug.org/conf <http://www.iiug.org/conf>;
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on my employer, Oninit, the IIUG, nor any other
> > organization with which I am associated either explicitly or implicitly.
> > Neither do those opinions reflect those of other individuals affiliated
> > with any entity with which I am affiliated nor those of the entities
> > themselves.
> >
> >
> >
> > On Wed, Dec 30, 2009 at 5:06 PM, joe <joeclhua@gmail.com
> > <mailto:joeclhua@gmail.com>> wrote:
> >
> > isql version : 7.32fc2
> > ids version: 11.5FC3 upgrade to 11.5FC5
> > After upgarading to 11.5fc5.
> > Running isql
> > select form -> compile .
> > It will not list all the *.per source file.
> >
> > isql version not change.
> > Install steps:
> > 1. create a new directory
> > 2. install isql
> > 3. install ids
> > Anyone can help me?
> > _______________________________________________
> > Informix-list mailing list
> > Informix-list@iiug.org <mailto:Informix-list@iiug.org>
> > http://www.iiug.org/mailman/listinfo/informix-list
> >
> >
>
> Art,
>
> Manoj's response points to the problem. The server install also
> installs a new version of the CSDK which tramples on several libraries
> used by ISQL & 4GL. It doesn't matter where DBPATH points, the older
> stuff is broken.
>
> There's no indication I've seen as to how to fix it. Would reinstalling
> ISQL break the CSDK? Can the CSDK be deinstalled & replaced with an
> older one? If so which is recommended? Is there a fixed version of the
> CSDK available?
>
> I can't see Obo's solution of installing in different directories
> helping - whatever library path is set to it's bound to resolve to one
> set of libraries or the other and unless the CSDK will work with the
> older libraries one or other of the toolsets is going to end up using
> the wrong libraries.
>
> I'd noticed the problem on my own Linux laptop a few days ago but not
> got round to investigating it. In fact I'd assumed it was probably yet
> another non-backward-compatible Linux upgrade until this thread appeared
> but in fact it must have been the CSDK I installed earlier.
>
> --
> Ian
>
> The Hotmail address is my spam-bin. Real mail address is iang
> at austonley org uk
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
On Dec 30, 10:06 pm, joe <joecl...@gmail.com> wrote: > isql version : 7.32fc2 > ids version: 11.5FC3 upgrade to 11.5FC5 > After upgarading to 11.5fc5. > Running isql > select form -> compile . > It will not list all the *.per source file. > > isql version not change. > Install steps: > 1. create a new directory > 2. install isql > 3. install ids > Anyone can help me? For the source files isql will first look in the current directory. Are you in that directory when you launch isql. isql will also look in the directories specified by DBPATH. is that environment varieable set and exported?
> For the source files isql will first look in the current directory. > Are you in that directory when you launch isql. > > isql will also look in the directories specified by DBPATH. is that > environment varieable set and exported? I run isql with full path name , and change directory ( cd) to the directory that perform souce file located. Also, Try Art's suggestion set DBPATH. Now , I have to wait for FC6 and pray for luck.
joe wrote: > isql version : 7.32fc2 > ids version: 11.5FC3 upgrade to 11.5FC5 > After upgarading to 11.5fc5. > Running isql > select form -> compile . > It will not list all the *.per source file. > > isql version not change. > Install steps: > 1. create a new directory > 2. install isql > 3. install ids > Anyone can help me? Security was a big "feature" brought in .... Check directory permissions ... i.e. where is your source file?