Re: Remote Connect Failure thru 4gl

Try changing dhl_intraTCP to dhl_intratcp Paul Watson WF Software Ltd Tel: +44 1436 674729 Fax: +44 1436 678729 www.wfsoftware.com/informix # If you broke it, hide the evidence >>> Chetan Anand <canand@systems.dhl.com> 11/02/99 07:09PM >>> This is a multi-part message in MIME format. --------------F00128E39534B9AF6F1707C0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Thanks Art, Alnis I checked thruough INFORMIXSERVER, INFORMIXDIR, ONCONFIG Looks okay. Here is the info for any clue # --- 4gl code database exb_canand@i920_shm main define li_count integer select count(*) into li_count from dhl_intra@dhl_intraTCP:my_table display "Total Records : ", li_count end main /* Env Variables */ $ echo $INFORMIXDIR /opt/informix/ifmx_920 $ echo $INFORMIXSERVER i920_shm $ echo $ONCONFIGonconfig.i920 $ more $INFORMIXDIR/etc/sqlhosts # -- sqlhosts i920_shm onipcshm lhost i920_shm dhl_intraTCP onsoctcp rhost 1900 $ grep 1900 /etc/servicesdhl_intraTCP 1900/tcp This is the error message SQL statement error number -908. Attempt to connect to database server (dhl_intratcp, conerr=-25555, oserr=0) failed. Does it matter if server name is defined as combination of lower/upper case. Any clue. Thanks for any help on the problem. Rds "Art S. Kagel" wrote: > How are you specifying and using the remote hostname in the 4GL server? > Do you: > > o Let the server default to $INFORMIXSERVER and have that set to the > remote and connect to the databasename alone? > o Read the server from $INFORMIXSERVER, the commandline, or some other > source and combine it in source with the databasename in a DATABASE > CONECT statement? > o Do you do as above but connect to the server alone with CONNECT then > execute a DATABASE statement? > > Please post the code snips that show this. It is probably something > trivial like a missing at (@) sign or something. > > Art S. Kagel > > Chetan Anand wrote: > > > > Hi: > > > > Hi > > > > I have a question, if isql and dbaccess can connect to remote dbserver ( > > xxx_svr ) > > from command line, why 4gl runtime keeps flashing me following message > > > > Attempt to connect to database server (xxx_svr, conerr=-25555, oserr=0) > > failed. > > > > I have checked through all services, sqlhosts, .rhosts everything looks > > okay as I mentioned isql/dbaccess works fine on the remote server and I > > managed to put in couple of select statements which returns perfectly > > normal. > > > > Local Informix ver : Informix Dynamic Server 2000 Version 9.20.H > > Remote Informix ver : INFORMIX-Universal Server Version 9.14.UC5 > > Local Host : HP UX B.11.00 > > Remote Host : HP UX B.10.20 > > > > Any clues > > > > Thanks in advance for any help in the matter > > > > Rgds --------------F00128E39534B9AF6F1707C0 Content-Type: text/x-vcard; charset=us-ascii; name="canand.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Chetan Anand Content-Disposition: attachment; filename="canand.vcf" begin:vcard n:Anand;Chetan tel;work:<b>650+ 425 5327</b> x-mozilla-html:TRUE org:<img src=http://www.dhl.com/art/logo.gif>; <br> <b>DHL Systems Inc. </b> version:2.1 email;internet:canand@systems.dhl.com title:<i>Senior Software Engineer</i> adr;quoted-printable:;;700 Airport Blvd=0D=0ASuite 300;Burlingame;California;94010;USA fn:<font size=+1> Chetan Anand </font> end:vcard --------------F00128E39534B9AF6F1707C0--