Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

isql run error after upgrade

12 views
Skip to first unread message

joe

unread,
Dec 30, 2009, 5:06:14 PM12/30/09
to
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?

Obnoxio The Clown

unread,
Dec 30, 2009, 5:11:43 PM12/30/09
to IIUG Informix List

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.

Manoj Vakeel

unread,
Dec 30, 2009, 5:39:37 PM12/30/09
to joe, informix-l...@iiug.org, inform...@iiug.org

CSDK defect.

http://www.informixmag.com/content/view/19795/27/

-Manoj



From: joe <joec...@gmail.com>
To: inform...@iiug.org
Date: 12/30/2009 04:11 PM
Subject: isql run error after upgrade
Sent by: informix-l...@iiug.org





_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list


Ian Goddard

unread,
Dec 30, 2009, 6:20:45 PM12/30/09
to
Manoj Vakeel wrote:
>
> CSDK defect.
>
> http://www.informixmag.com/content/view/19795/27/
>
> -Manoj
>
>
>
> From: joe <joec...@gmail.com>
> To: inform...@iiug.org
> Date: 12/30/2009 04:11 PM
> Subject: isql run error after upgrade
> Sent by: informix-l...@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
> Inform...@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

Art Kagel

unread,
Dec 30, 2009, 8:40:34 PM12/30/09
to joe, inform...@iiug.org
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 (a...@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.



joe

unread,
Dec 31, 2009, 5:46:45 AM12/31/09
to
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 .

Ian Goddard

unread,
Dec 31, 2009, 6:02:22 AM12/31/09
to
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 (a...@iiug.org <mailto:a...@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 <joec...@gmail.com
> <mailto:joec...@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
> Inform...@iiug.org <mailto:Inform...@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.

Art Kagel

unread,
Dec 31, 2009, 6:36:31 AM12/31/09
to joec...@gmail.com, inform...@iiug.org
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 (a...@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.




scottishpoet

unread,
Dec 31, 2009, 8:46:29 AM12/31/09
to

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?

roger

unread,
Dec 31, 2009, 9:25:08 AM12/31/09
to

> 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.

theBP

unread,
Dec 31, 2009, 9:48:08 AM12/31/09
to

Security was a big "feature" brought in ....

Check directory permissions ... i.e. where is your source file?

0 new messages