Re: OnLine, I-Star, I-Net, Q+E ODBC not working

Mike Dawson (Mike_Dawson@cc.chiron.com) wrote: : We are having similar problems at our site. We are using to TCP/IP to : communicate and have found that you need to add a line to the SERVICES : file on the PC stating that sqlexec is on port 1081. There is no absolute rule what port sqlexec has to be assigned to. You just have to make sure that it's the same port on all machines in your network. Furthermore, you don't even have to call the service "sqlexec", you can give it any other name you like. The mapping between the default name "sqlexec" and the actual service name is done via the startup command for sqlexecd (just give it the service name as an argument) and the sqlhosts file. All this is documented in the manuals. : Furthermore, it appears that : that file needs to be located in the INFORMIX\\BIN directory on the PC. This : is an administration problem for us. We would like to have one copy of the : services file out on the network. There should be a setting one can make in : the INFORMIX.INI file to tell I*Net where to look for the services file. Which vendor's TCP/IP are you using? Usually, the TCP/IP protocol stack keeps its "services" file in the same place as the "hosts" and other configuration files. This may be configurable by an environment variable. For some versions of PC/TCP, this is "FTP_ETC". Hope this helps, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+