Hi,

My setup

Redhat Linux v8
Informix Online
dbaccess 5.20.UC1
IBM INFORMIX-4GL Version 7.32.UC1 (i4gl)

INFORMIXDIR is set to /opt/informix
TBCONFIG=tbconfig.eng
INFORMIXSERVER=online
DBSERVERNAME=online
INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts.eng

/opt/informix/etc/tbconfig.eng
------------------------------
DBSERVERNAME online
NETTYPE soctcp,1,60,NET

sqlhosts.eng
-------------
online onsoctcp linux sqlexec

/etc/services
-------------
sqlexec 1542/tcp

/etc/hosts
----------
127.0.0.1 linux localhost.localdomain localhost

I have been fiddling with this setup for three days now, and my files
are still not compiling:

When running dbaccess I am able to create a database with tables no
problem.

BUT

When trying to compile a .4gl file with c4gl -c filename.4gl I get the
following error message:

Attempt to connect to database server (online) failed. See error
number -908

I am stumped. Any ideas out there?

Thanks in advance,

Du Toit Scheepers

"Du Toit Scheepers" <dutoit@infoagent.co.za> wrote in message
news:6a945109.0406101036.4101bfa4@posting.google.c om...
> When trying to compile a .4gl file with c4gl -c filename.4gl I get the
> following error message:
>
> Attempt to connect to database server (online) failed. See error
> number -908
>
> I am stumped. Any ideas out there?

Is I-STAR running: ie have you run $INFORMIXDIR/etc/sqlexecd as root?

"Neil Truby" <neil.truby@ardenta.com> wrote in message news:<2irp4nFplt8nU1@uni-berlin.de>...
> "Du Toit Scheepers" <dutoit@infoagent.co.za> wrote in message
> news:6a945109.0406101036.4101bfa4@posting.google.c om...
> > When trying to compile a .4gl file with c4gl -c filename.4gl I get the
> > following error message:
> >
> > Attempt to connect to database server (online) failed. See error
> > number -908
> >
> > I am stumped. Any ideas out there?
>
> Is I-STAR running: ie have you run $INFORMIXDIR/etc/sqlexecd as root?

Hi Neil,

I do not seem to have a file called sqlexecd anywhere on my machine.
Is I-STAR related to the tcp comms? Any idea where I can find the
I-STAR tool?

Thanks for your reply,

Du Toit

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


"Du Toit Scheepers" <dutoit@infoagent.co.za> wrote:

> Hi,
>
> My setup
>
> Redhat Linux v8
> Informix Online
> dbaccess 5.20.UC1
> IBM INFORMIX-4GL Version 7.32.UC1 (i4gl)
>
> INFORMIXDIR is set to /opt/informix
> TBCONFIG=tbconfig.eng
> INFORMIXSERVER=online
> DBSERVERNAME=online
> INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts.eng
>
> /opt/informix/etc/tbconfig.eng
> ------------------------------
> DBSERVERNAME online
> NETTYPE soctcp,1,60,NET
>
> sqlhosts.eng
> -------------
> online onsoctcp linux sqlexec
>
> /etc/services
> -------------
> sqlexec 1542/tcp
>
> /etc/hosts
> ----------
> 127.0.0.1 linux localhost.localdomain localhost
>
> I have been fiddling with this setup for three days now, and my files
> are still not compiling:
>
> When running dbaccess I am able to create a database with tables no
> problem.
>
> BUT
>
> When trying to compile a .4gl file with c4gl -c filename.4gl I get the
> following error message:
>
> Attempt to connect to database server (online) failed. See error
> number -908
>
> I am stumped. Any ideas out there?
>
> Thanks in advance,
>
> Du Toit Scheepers

"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