Re: Network connection.,,

Hi Tony. thabib@bob.zentropy.softaware.com wrote: > Hello all, > > I'm trying to connect to a INFORMIX-OnLine Version 7.12.UC1 (online > dynamic server) with a esql/c application (INFORMIX-ESQL Version > 7.12.UC1). > I have doubled-checked the sqlhosts files, onconfig, hosts.equiv, > hosts > files, and restarted the database engine, only to get a -908 SQLCODE > code > returned... What am I forgetting? > ==>check the following steps 1. Do you check the sqlhosts and the enviroment variables(INFORMIXDIR & INFORMIXSERVER) in the client side 2.Check the server's protocols, onipcshm or onsoctcp, that was listed in the onconfig's SERVERNAME & SERVERALIAS fields and sqlhosts's protocol field 3. Do you check the service port # of both side(server and client). Ths both service port # must be the same 4. If no above, another problem is the network problem(using the yellow page and so on...) Is there any way to check if Informix is actually listening on a port ==> onstat -g ath RSAM Version 7.12.TC3 -- On-Line -- Up 00:06:04 -- 9600 Kbytes Threads: tid tcb rstcb prty status vp-class name 2 c2453cc 0 2 sleeping(Forever) 7lio lio vp 0 3 c24569c 0 2 sleeping(Forever) 5pio pio vp 0 4 c245a50 0 2 sleeping(Forever) 6aio aio vp 0 5 c245e20 0 2 sleeping(Forever) 10msc msc vp 0 6 c25c678 0 2 sleeping(Forever) 8aio aio vp 1 7 c25c97c 0 2 sleeping(Forever) 9aio aio vp 2 8 c25ce28 c168010 4 sleeping(secs: 1) 1cpu main_loop() 9 c25d8cc 0 2 running 12soc soctcppoll 10 c2743c8 0 2 running 13soc soctcpio 11 c274c4c 0 3 sleeping(Forever) 1cpu soctcplst ==> listen thread * check the sqlhosts's service field and services file 12 c274fec c168440 2 sleeping(Forever) 3cpu flush_sub(0) 13 c2753e8 0 4 sleeping(Forever) 1cpu kaio 14 c275900 c168870 2 sleeping(secs: 52) 1cpu btclean 16 c275edc 0 4 sleeping(Forever) 3cpu kaio 30 c2d8370 c168ca0 4 sleeping(secs: 1) 1cpu onmode_mon 32 c2d88f8 0 4 sleeping(Forever) 4cpu kaio > besides using ESQL/C? And can i connect over a network by using > infperl, > or any other langauges? Any help would be greatly appreciated. > > Thanks, > > Tony Habib > > Tony Habib > Software Developer, Zentropy Interactive > > thabib@zentropy.com > thabib@cs.sci.csupomona.edu > thabib@netroplex.com > > "Nothing travels faster than the speed of light, except for bad news > which > obeys its own special laws." > -- Douglas Adams, "Mostly Harmless" I am glad to give you some help.