Hi all, I would like to know c

[GRP]

Hi all,


I would like to know configuration set up for accessing remote database on other server by INFORMIX. Both ther servers are having IDS 7.31 and Unix. Telnet & remote copying is already working between two servers.

GRP

 

[Surachai]

You have to configure the sqlhosts files on each server.By added server name and its service port likes below listing.

Suppose,
Config. on server 1 :
informix server name = on_server1
service port = 1601

Config. on server 2:
informix server name = on_server2
service port = 1602
#----------------------------------------------------#
sqlhosts on server 1 must like this:
on_server1 ontlitcp server1 1601
on_server2 ontlitcp server2 1602

sqlhost on server 2 :
on_server2 ontlitcp server2 1602
on_server1 ontlitcp server1 1601

 

[GRP]

Hi Surachai,

Thanks for your suggestion. I had tried out your suggestion, our connection is not through ontlitcp. It is by onsoctcp. I changed the /etc/services and /etc/hosts.equiv file and could able to access the remote database successfully.

Thanks again for your tip,

G.R.P.