Re: Composer/I-Net Issue

cfrank@gw.dem.state.in.us wrote: :Hi all, : :Has anyone experienced problems using I-Net with Texas Instruments' :development tool, Composer (to access Informix databases)? Our issue :is when a user accesses the database through the Composer :application, it affixes his/her userid (taken from setnet) to the tables. :Another user, attempting to run sql against the tables, will receive a :"database not found" error. A workaround was to have the users sign :on with the same id (the owner of the database), and synonyms created :for each user for each table he/she needs to access (an extremely time :consuming process!). : :Any thoughts or suggestions on a better solution would be appreciated. Yes. Run. Find another tool. This is seriously meant, and why I posted. (It's quite some time since I looked at IEF last, but at that time I could see no possible usefull purpose for it except handing over a tremendous amount of dollars to TI. I believe it have improved significantly in the meantime though.) Although I do not realy know a good answer I will however try to give some clues: I assume you mean that the sql generated looks something like: select username.tablename.columnname... from username.tablename... as per the ANSI standard. If a set of tables is accessed by the user who have created them there is no problem. If someone else is accessing the same table the application have to know about who created the table and prepend that username, not the username of the user that now is accessing the table. How the ANSI commitee could come up with something like this I have no clue, but stupid it is. Personal access only to corporate data??? The designers of IEF aren't stupid though, so they knew about this behaviour when they created the product. There is some standard way of setting up your environement (outside I-Net of course) that handles this senario. TI support will know of this. If they by any chanse shouldn't be able to handle this easily I would sure start running. :Thank you. You are welcome. :Additional info: OnLine DS, version 7.10.UC2 Be *very* carefull with this version of OnLine. It's old and contains quite a few bugs. You should definitely upgrade to a newer version. May be you have to upgrade AIX also to be able to do that. I don't know, check with Informix. : I-Net 5.01 : IEF Composer 3.00 : Platform: AIX 3.2.5, RS6000 Powerserver 570 Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org