Re: Help! INFNET

In <1993May14.104901@hhs406.d9.hamburg.sni.de> mott@hhs406.d9.hamburg.sni.de (Philipp Mott) writes: >I have some problems with my Informix-system. >My configuration is: > Client : UNIX, ISQL 4.1, INFNET > Net : TCP > Server: UNIX, ONLINE 4.1, STAR >The local user is not present in the server's passwd; mapping is done with the >$HOME/.netrc file. >P#1: > Whenever I try to create a database through ISQL at the client, a local > SE-database (*.dbs) will be created ! It seems impossible to create a > remote ONLINE-database, even if I use the //<HOST>/<database> > format. The SQLEXEC-variable is correctly set to $INFORMIXDIR/ > sqlexec_tcp and there is *NO* SE-backend on the local machine ! Page 30 of the I-NET/I-STAR User Guide (4.1) clearly states: "If you are using a client running INFORMIX-NET, you cannot create a database on a remote UNIX server running INFORMIX-NET TURBO or INFORMIX-STAR and vice versa." I'm not familiar with sqlexec_tcp, but I guess it *IS* an SE-backend! (although presumably unlicensed as such). >P#2: > A local user who is not known at the server possesses a '.netrc' file to > map to a known user. When I connect to the backend everything looks > good; the backend logging mechanism reports a logon as the mapped > user. I have a table which is only selectable by the mapped user (that > one which is known at the server). When I try to retrieve data using a > PERFORM-format, sperform reports a number of rows found, but it > doesn't display them ! It only displays data when the table has select- > permission for 'public'. Using SQL I get the data, it's only PERFORM > not obeying. Sounds like a bug! I can't think of a workaround. graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.