RE: Select from two OnLine 5.20 instances, both on 1 machine
Hi Colin.
Try the following.
telnet pineb 1542
Can you establish connection ?
If not, netstat -an | grep
e.g)
# netstat -an | grep 325
172.16.174.230.32500 *.* 0 0 49152 0 LISTEN
grep 32500 /etc/services
tsutoo520uc1 32500/tcp
sqlhosts
tsutoo520uc1 olsoctcp urraco tsutoo520uc1
Regards.
--
Tsutomu Ogiwara from Tokyo Japan.
>From: "Colin" <mccolingrath@gmail.com>
>Reply-To: "Colin" <mccolingrath@gmail.com>
>To: informix-list@iiug.org
>Subject: Select from two OnLine 5.20 instances, both on 1 machine
>Date: 14 Nov 2005 08:56:53 -0800
>
>Two instances of the OnLine engine running on one machine
>(tbconfig.gtest, tbconfig.prod)
>
>$INFORMIXDIR/etc/sqlhosts:
>pineb_gtest olsoctcp pineb sqlturbo2
>pineb_prod olsoctcp pineb sqlturbo3>
>Entries in /etc/services:
>sqlturbo2 1542/tcp # informix pineb_gtest
>sqlturbo3 1543/tcp # informix pineb_prod
>
>Two sqlexecd daemons running:
>/usr/informix_5.20/lib/sqlexecd sqlturbo3 -l
>/usr/informix_5.20/prod_sqlexecd.log
>/usr/informix_5.20/lib/sqlexecd sqlturbo2
>
>Can't seem to connect to the two instances at the same time, tried with
>ODBC from a PC, the following is from within dbaccess on the machine
>itself:
>
>select A.user_id g_user_id,
> b.user_id p_user_id
>from tracsy@pineb_gtest:mu_user_02 A,
> tracsy@pineb_prod:mu_user_02 B
>where g_user_id = p_user_id
>
> 908: Attempt to connect to database server (pineb) failed.
> Bad file numbersending to informix-list