Re: Remote database connection
Posted in 2003
Hi Brett.
Make sure your sqlhosts and services.
In my case.
Server1 is tsutoo930uc3.(Linux)
Server2 is tsutoo731ud2r1.(Solaris)
Both server is an On-Line mode.
sqlhosts
cspc08
tsutoo930uc3 onsoctcp cspc08 tsutoo930uc3
tsutoo731ud2r1 onsoctcp physalis 32434
physalis
tsutoo731ud2r1 ontlitcp physalis 32434
tsutoo930uc3 ontlitcp cspc08 32411
services in cspc08
tsutoo930uc3 32411/tcp
Regards.
--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592
>From: "brett simpson" <bsimpson@actrol.com.au>
>Reply-To: "brett simpson" <bsimpson@actrol.com.au>
>To: informix-list@iiug.org
>Subject: Remote database connection
>Date: Wed, 24 Sep 2003 09:04:46 +1000
>
>Hi
>
>I have 2 IDS (7.2) servers.
>
>I have R4GL on server1 and have written a program that needs to access data
>in a database on server2.
>
>I have read all the informix docs on remote servers and have configured the
>servers as recommended (sqlhosts, services etc)
>
>When I DBACCESS from server 1 to server 2, I can see server 2 in the
>connection menu.
>
>When I select server 2 it asks for a user name and password (I use
>informix)
>but it dosnt connect, it just says running.... at the bottom of the screen
>(like its trying to connect) and thats it......
>
>I can rlogin from server1 to server2 so OS permissions dont seem to be the
>problem.
>
>I can access server2 locally using informix so informix permissions dont
>seem to be the problem.
>
>WHAT IS MY PROBLEM ???????
>
>WHAT HAVE I MISSED ???????
>
>HELP !!!!
>
>
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
sending to informix-list