Re: I-STAR / INFORMIX 5

Peries, Chaminda wrote: > Hi, > > I hope someone who has dealt with Informix5 / I-STAR / CLI can help me > out with some configuration issues. > > I have a project pending where I have to use an Informix-5 database and > Informix -cli for connectivity. I found out the hard way, that the > database connection /communiv\\cations stuff was not built in as in > Informix 7. We had to buy Informix-STAR for this. > > Well, I have run into some trouble in configuring I-STAR. I installed > ok. But what else do I need to do. The Documentation is as always > confusing & misleading. > > Do I need to run ( SQLEXECD , SQLTURBO ) or do they get invoked by some > other process. What configuration files are effected & how ? > > eg:- > > SQLHOSTS file > ONCONFIG file > etc/services file > > When I try to run sqlexecd it says that I am using the wrong protocol , > error no 25507. > > Thanks, > > Chaminda Peries It's a long time ago I have done something with Informix 5 / I-Star. As I remember, basically it's this: Files you need on the server side: /etc/hosts.equiv /etc/hosts /etc/services with an entry specifying the port and protocol, e.g. star 1541/tcp or sqlexec 1525/tcp You do not need an $INFORMIXDIR/etc/sqlhosts file on the server side an all cases, but you need one if * multiple sqlexecd daemons should run * the servername in the DATABSE statement is not the same as the remote UNIX server's TCP/IP hostname * The servicename you are trying to access is not sqlexec And you have to tun the daemon by "sqlexecd [servicename]" where servicename defaults to sqlexec and must match an entry in /etc/services If you need also an $INFORMIXDIR/etc/sqlhosts file, you must enter the servername specified in this file into the SERVERALIAS of onconfig.std. Files you need on the client side: /etc/hosts (/etc/hosts.equiv) /etc/services (should be equal on all systems) $INFORMIXDIR/etc/sqlhosts with an entry like this: remserver tcp remhost star | | | onconfig /etc/hosts /etc/services (server side) you then access the database by DATABASE salesdb@remserver This looks up remserver in /etc/hosts and $INFORMIXDIR/etc/sqlhosts (servername), finds the servicename star, looks it up in /etc/services, finds port 1541 and talks to the remote system. The remote system calls sqlexecd according to the port in /etc/services. If sqlexecd is started with a servicename (e.q. sqlexecd star, necessary if it's Informix Online and not SE - as far as I remember) it looks up the servicename in $INFORMIXDIR/etc/sqlhosts, extracts the servername and connects to the database engine. Hope this helps, although it's confusing. Have a try. Helmut Leininger