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. > 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. OK. Yes you have to run sqlexed. The service name passed to it on the command line must correspond to a line in sqlhosts that specifies a network connection (ex tcp), the name of the local machine, and a server name specific to the network connection. You cannot specify the same service as is being used for local shared memory or pipe connections. If your normal connection has an sqlhosts entry like this: fredsrv shm fred sqlsvc you also need an entry: fredsrv_net tcp fred sqlnetsvc with appropriate entries in /etc/services and then execute sqlexecd as: sqlexecd sqlnetsvc -l $INFORMIXDIR/istar.log & Art S. Kagel