Re: INFORMIX 5 : is there a SQLHOSTS file ?

}From: "Billy Wheeler" <billy@west.co.za> }Date: Thu, 4 Sep 1997 08:24:43 +0200 }X-Informix-List-Id: <list.16341> } }On 3 Sep 97 at 17:02, Peries, Chaminda wrote: }> In the $INFORMIXDIR/etc directory there is no SQLHOSTS file. Instead }> there is a TBCONFIG file. } }TBCONFIG is the equivalent of ONCONFIG. } }> Where do I get The SERVICE NAME for the database from ? I found }> the database server name in the TBCONFIG file. } }You have to create an entry in /etc/services. AFAIK, the name used }there is the service name. } }> When I called up Informix tech support they said to create a file }> called SQLHOSTS with similar info as in Informix 7 in this }> directory. but this didn't work . } }I'm not entirely surprised. Online 5 has no concept of an SQLHOSTS file... On the contrary, OnLine 5 does use an sqlhosts (lower case) file, but only with I-Net or I-Star. In fact, I-Net and I-Star version 4.x used an sqlhosts file, though the contents of the file was different. The version 5 sqlhosts file uses the same format as the more recent versions, but there are fewer connectivity types (oltlitcp, seipcpip, olsoctcp, etc; no olipcshm or olipcstr). Under Version 6 and later, the sqlhosts file is mandatory. Under version 5, the sqlhosts file is optional; it is only needed if you are using I-Net or I-Star. Under version 7.2x at least, if you have an entry for a server in the sqlhosts file, then that server name had better be one of the names configured in the DBSERVERNAME and DBSERVERALIASES entries of the ONCONFIG file. Under version 5.0x, this validation is not done. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> PS: Warning I do not reply to messages with anti-spam in the return path.