Re: remote connection question

> I have two unix boxes each running an instance of an Informix database > (one production the other development). I would like to be able to > access the development instance remotely from the production server. > What do I need to set up in order to do that? They are already > "trusted" between each other. Do I need to install I-Connect on one or > both of the servers? Can this be done simply with the proper sqlhosts > entries (and/or various other entries)? I know I can reference the > other server by setting INFORMIXSERVER, what about the ONCONFIG and > SQLHOSTS environment variables? Should they change? On your production server: * Set INFORMIXSERVER to point to the network-aware server name/alias. * Create an entry in your sqlhosts file. You can probably cut and paste from your development sqlhosts file. * Create an entry in your /etc/services file. Again, you can get this from your development /etc/services file. * Add the development server name in your /etc/hosts, unless you're using DNS/NIS. * ONCONFIG doesn't really matter if you're doing remote connections...you should probably be doing any administration locally on whatever machine needs any changes. * INFORMIXSQLHOSTS just points to your local sqlhosts file, which contains an entry referencing to your development instance.