Re: c4gl Compile Time Connection Error

"Doug Lawry" <lawry@nildram.co.uk> wrote in message news:<cabpdd$831$1@nntp0.reith.bbc.co.uk>... > INFORMIXSQLHOSTS is not listed as a known environment variable in the 4GL > manual: try creating the standard file "/opt/informix/etc/sqlhosts". Also, > try setting ONCONFIG as well TBCONFIG. DBSERVERNAME is generally not a > recognised environment variable. You shouldn't need "sqlexecd" unless you > are running Standard Engine. > > Let me know how you get on! > > Regards, > Doug Lawry > www.douglawry.webhop.org > > <snip> Hi Doug, Thanks for the reply, My Informix user's .bash_profile now contains: SQLEXEC=$INFORMIXDIR/lib/sqlturbo TBCONFIG=$INFORMIXDIR/etc/tbconfig.eng ONCONFIG=$INFORMIXDIR/etc/tbconfig.eng INFORMIXSERVER=online I have also created a file called sqlhosts in /opt/informix/etc online onsoctcp linux sqlexec For the rest my setup remains the same, and unfortunately so does the error message when trying to compile a .4gl file :-( Attempt to connect to database server (online) failed. See error number -908. Dunno if this could help diagnose the problem, but when running the c4gl -c filename.4gl command the system take quite some time (about a minute or so) before it responds. Is it trying to connect to the port, or listening on the port or something? I appreciate your help, Regards, Du Toit Scheepers

4GL 7 to OnLine 5.20, I think you might need the sqlexecd running. Is the sqlexecd running? As root run $INFORMIXDIR/lib/sqlexecd. Maybe use the logging options too johnd dutoit@infoagent.co.za (Du Toit Scheepers) wrote in message news:<6a945109.0406132329.1681c6a6@posting.google.com>... > "Doug Lawry" <lawry@nildram.co.uk> wrote in message news:<cabpdd$831$1@nntp0.reith.bbc.co.uk>... > > INFORMIXSQLHOSTS is not listed as a known environment variable in the 4GL > > manual: try creating the standard file "/opt/informix/etc/sqlhosts". Also, > > try setting ONCONFIG as well TBCONFIG. DBSERVERNAME is generally not a > > recognised environment variable. You shouldn't need "sqlexecd" unless you > > are running Standard Engine. > > > > Let me know how you get on! > > > > Regards, > > Doug Lawry > > www.douglawry.webhop.org > > > > > <snip> > > Hi Doug, > > Thanks for the reply, > > My Informix user's .bash_profile now contains: > > SQLEXEC=$INFORMIXDIR/lib/sqlturbo > TBCONFIG=$INFORMIXDIR/etc/tbconfig.eng > ONCONFIG=$INFORMIXDIR/etc/tbconfig.eng > INFORMIXSERVER=online> > I have also created a file called sqlhosts in /opt/informix/etc > > online onsoctcp linux sqlexec> > For the rest my setup remains the same, and unfortunately so does the > error message when trying to compile a .4gl file :-( > > Attempt to connect to database server (online) failed. See error > number -908. > > Dunno if this could help diagnose the problem, but when running the > c4gl -c filename.4gl command the system take quite some time (about a > minute or so) before it responds. Is it trying to connect to the port, > or listening on the port or something? > > I appreciate your help, > > Regards, > > Du Toit Scheepers