Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

isql run error after upgrade

 
   Database Help (Home) -> Informix RSS
Next:  Removing XML Extender  
Author Message
joe

External


Since: Dec 30, 2009
Posts: 3



(Msg. 1) Posted: Wed Dec 30, 2009 2:06 pm
Post subject: isql run error after upgrade
Archived from groups: comp>databases>informix (more info?)

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?

 >> Stay informed about: isql run error after upgrade 
Back to top
Login to vote
Obnoxio The Clown

External


Since: Jan 16, 2008
Posts: 162



(Msg. 2) Posted: Wed Dec 30, 2009 6:25 pm
Post subject: Re: isql run error after upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.

 >> Stay informed about: isql run error after upgrade 
Back to top
Login to vote
Ian Goddard

External


Since: Dec 14, 2007
Posts: 16



(Msg. 3) Posted: Wed Dec 30, 2009 7:25 pm
Post subject: Re: isql run error after upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Manoj Vakeel wrote:
>
> CSDK defect.
>
> http://www.informixmag.com/content/view/19795/27/
>
> -Manoj
>
>
>
> From: joe
> To: informix-list.DeleteThis@iiug.org
> Date: 12/30/2009 04:11 PM
> Subject: isql run error after upgrade
> Sent by: informix-list-bounces.DeleteThis@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.DeleteThis@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&...=swg1IC

Is there a workround?

--
Ian

The Hotmail address is my spam-bin. Real mail address is iang
at austonley org uk
 >> Stay informed about: isql run error after upgrade 
Back to top
Login to vote
joe

External


Since: Dec 30, 2009
Posts: 3



(Msg. 4) Posted: Thu Dec 31, 2009 2:46 am
Post subject: Re: isql run error after upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 .
 >> Stay informed about: isql run error after upgrade 
Back to top
Login to vote
scottishpoet

External


Since: Jan 16, 2008
Posts: 29



(Msg. 5) Posted: Thu Dec 31, 2009 5:46 am
Post subject: Re: isql run error after upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Dec 30, 10:06 pm, 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?

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?
 >> Stay informed about: isql run error after upgrade 
Back to top
Login to vote
roger

External


Since: Dec 31, 2009
Posts: 1



(Msg. 6) Posted: Thu Dec 31, 2009 6:25 am
Post subject: Re: isql run error after upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

> 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.
 >> Stay informed about: isql run error after upgrade 
Back to top
Login to vote
Ian Goddard

External


Since: Dec 14, 2007
Posts: 16



(Msg. 7) Posted: Thu Dec 31, 2009 6:25 am
Post subject: Re: isql run error after upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 )
>
> 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 <
> > 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.DeleteThis@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
 >> Stay informed about: isql run error after upgrade 
Back to top
Login to vote
theBP

External


Since: Feb 11, 2009
Posts: 2



(Msg. 8) Posted: Thu Dec 31, 2009 11:25 am
Post subject: Re: isql run error after upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?
 >> Stay informed about: isql run error after upgrade 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
What package is isql in? - I just, after much arm twisting, got my management to update our license for Informix SE (just a license to port to IDS), 4gl RDS. I have installed them, but I can't find isql. Is that in a different package or am I missing something. I know that I can....

isql vs. dbaccess - A couple people I work with swear that dbaccess has given different results from isql when given the same query. I've never heard of this and believe if it were the case it would have to be a bug. Apparently they believe isql was returning the correc...

ISQL install problem - Hey guys, I'm looking for a little help with regards to an ISQL installation. We're currently migrating from SCO open server and informix 7.x to a Red Hat Enterprise 4 server with IDS 10. Under the initial installation, we simply installed IDS and..

isql/sperform/sacego and IDS 7.31 - Our machine is Solaris 2.8, running IDS 7.31.UD6 and we are using the tools (isql, ACE & PERFORM) 7.20.UE1. I'm aware these are old versions, our previous attempts to use later versions of the tools came unstuck on new 'features' which had developed...

ISQL checks current directory before DBPATH? - Since upgrading to Informix SE V7.25 UC6R1 and ISQL V7.32 UC4, it seems that ISQL is checking for databases in the current working directory *before* looking in DBPATH. IBM support confirmed that this is the behavior and did not know any way to change..
   Database Help (Home) -> Informix All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]