Re: INFORMIX - esql/c - DB-connection

Stephan Schnieber (alcapone@PC50.zrz.TU-Berlin.DE) wrote: > I have to write a esql/c-program. The problem is the executable > must run on an other computer than the dbserver. I think I have > to use the following environmentvariables: > INFORMIXSERVER > INFORMIXDIR > What I have is following: > - IP-adress from host on which the db-engine is running > - portnumber (servicename) > I want to know what I have exactly to do: > which systemfiles must be modified (e.g. > /etc/hosts, > INFORMIXDIR/etc/sqlhosts) > Whats about the permissions - how does the system know who is > accessing the db (by uid?). > P.S.: the db-engine is running under 7.x > I envelop the progam under 4.x Stephan, I don't know about using the old software for your client. I know that you would require a separate product (Informix Net) for client server communications if you had a client version 5, but I have no experience with version 4 or lower. Since the networking software was not bundled until version 6, I think you will need the extra components. I can let you know what the procedure is for version 6 and up though: You should have INFORMIXDIR set and an entry for your remote server in $INFORMIXDIR/etc/sqlhosts (see manual for entry syntax). The service name should appear in /etc/services for both machines. Authentication is done by effective uid. If your usernames and numbers match on both systems, you connect the same way you do to a local server, but if the name spaces are not the same, you will have to use a .netrc file (man netrc for details). Hope this helps, Kurt Mehlhoff kurt@infoadvan.com