Re: Online config for I-NET PC 5.01 to Online 7.1

Hi Mark, This setup is quite straighforward. First lets make a few assumptions for the purposes of this example. Unix machine where OnLine is running has a TCP/IP hostname of 'server1' in /etc/hosts (or NIS database) TCP/IP port number to use (c.f. OnLine 5.0) is defined in /etc/services (or NIS) with name 'ifxsrv1'. DBSERVERNAME in OnLine 7.1 ONCONFIG file is 'dbserver1' Your sqlhosts file ($INFORMIXDIR/etc/sqlhosts) will look like this: dbserver1 onsoctcp server1 ifxsrv1 OR, if your OnLine port uses TLI instead of sockets (check release notes) dbserver1 ontlitcp server1 ifxsrv1 When you bring OnLine up, it will use the ONCONFIG DBSERVERNAME as an index into the sqlhosts file and determine that it must listen for client connections on port 'ifxsrv1'. If you also wish to use shared memory connectivity for local Unix clients youe will need a DBSERVERALIASES parameter with a different name, say 'dbserver1shm' and an additional line in sqlhosts dbserver1shm onipcshm server1 someuniquestring Hope that helps, Chris Jenkins Mark Davis wrote: > We have a client that has Online Dynamic Server Ver 7.1. I have no problem > setting up 5.x for remote SQL access, but how do I configure a 7.1 engine > to do this? I understand that the engine "automatically" creates a thread > for each request, but how do I get any kind of response out of the engine? > > Also, after looking at several chapters in the manual the client faxed to me > I believe I understand how the sqlhosts file is used for connecting to other > servers (which we don't need), but their is one statement that says that > the sqlhosts file must be present on a machine that is ONLY acting as a > server. What role does this play for the server? Does this mean I have > to have 1 entry in the sqlhosts file for EACH AND EVERY COMPUTER that may > wish to do doe remote access via TCP/IP? And a unique ALIAS name in the > onconfig file for each one of them? This seems unlikely since you could > potentially have hundreds of machines that may all access the same server. -- Chris Jenkins (chrisj@informix.com) >>> All statements and opinions are mine and should in no way <<< >>> be construed as representing those of Informix Software <<<