RE: fglschema error

Hello Florencia,
 
Thanks for the quick reply.
 
$INFORMIXDIR/sqlhosts file is ok. $INFORMIXDIR/etc/$ONCONFIG and NETTYPE,
DBSERVERALIAS parameters looks ok too.
 
Here's my "fglrun -V" output:
 
fglrun 620.201                                           
Built Nov 26 2004 17:44:26                               
(c) 1989-2004 Four J's Development Tools                 
Database interface: INFORMIX-ESQL VERSION 9.xx (Standard)
 
And here's the "esql -V" output:
 
IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.UC3
Software Serial Number RDS#N000000                                
 
 

-----Original Message-----
From: [email protected] [mailto:[email protected]]
Sent: Thursday, March 31, 2005 1:21 PM
To: [email protected]
Subject: RE: [fourjs-users] fglschema error


Hi Nebab,
 
I guess you should check your conectivity configuration in Informix :
 
1) $INFORMIXDIR/etc/sqlhosts
 
2) $INFORMIXDIR/etc/$ONCONFIG : NETTYPE, DBSERVERNAME, DBSERVERALIASES, ...
 
Also, chechk your runner is correctly built against your database engine.
What's the output of "fglrun -V" command ? The "Database front end" line
should match your Engine/Client-Sdk version. If you need more details on
this, let me know.
 
Florencia

-----Mensaje original-----
De: [email protected] [mailto:[email protected]]
Enviado el: Jueves, 31 de Marzo de 2005 14:16
Para: [email protected]
Asunto: RE: [fourjs-users] fglschema error


Hello Nuno,
 
There is definitelly a 4J's to informix connection problem!  I can run
dbexport, dbschema, and dbaccess and connect to informix database without
any issues; but "fglschema" fails intermittently.   Here's the other error
message we're getting on a successfully compiled program:
 
SQL statement error number -25588.                             
The appl process cannot connect to the database server prod_shm
SYSTEM error number 22.                                        
 
Is there an 4J utility I can run to check dbase connectivity?  What else can
I check?  Please advise.
 
 
 
 

-----Original Message-----
From: [email protected] [mailto:[email protected]]On
Behalf Of Nuno Godinho
Sent: Wednesday, March 23, 2005 11:46 AM
To: [email protected]
Subject: RE: [fourjs-users] fglschema error


Hi Nebab!
    I would risc to say you could have a connection problem to your
database.
    What about try a dbexport or a dbschema just to see what happens ?
 
    HIH
    Nuno Godinho
 
 
-----Mensagem original-----
De: June Nebab [mailto:[email protected]]
Enviada: quarta-feira, 23 de Março de 2005 16:31
Para: [email protected]
Assunto: [fourjs-users] fglschema error



Hello,
 
I sent an email a few days ago but did not get any response at all about an
fglschema error i'm getting whenever running it.   So here is the problem
again and i'm hoping perhaps someone knows the answer.
 
I'm getting the following error whenever regenerating new database schema
file(s) in my $FGLDBPATH. 
 
"ERROR: "<dbname>" The cursor or statement is not available."
 
Fglschema works only after a few tries sometimes it just works on the first
try.  What could be wrong?
 
 
Regards,
June Nebab