Re: Informix 5.0 and HP-UX client

Ilkka Raisanen <ilkka.raisanen@kcl.fi> wrote: :'yvind Gjerstad wrote: : :>> ...snip :>> One person said that it is not possible to make a UNIX to UNIX :>> client/server system based on the Informix ver. 5.0. Is that true? :> :> No. : :Yes, that makes our life easier. Now I would be very happy, if :someone could describe a solution little deeper for me. (I am very new :in this area, so all information is welcome.) : :I have a few days time to specify a system, which includes our customers :data base server and our client program running on a separate :workstation. :We need to read data from data base system, which has the following :configuration: : :HW: SUN Sparc :OS: Solaris :DB: Informix On-line 5.0 : : :Our client SW is made by C language and it is running on the following :platform: : :HW: HP715/64 :OS: HP-UX 9.05 : : :I think, that the best solution is that we need not to make changes to :the SUN Sparc station. Now I have three questions: : :1. Can we read data from Informix On-line 5.0 without a need to modify :data base servers's configuration? If that is possible, what libraries :we need to link into our client SW? : :2. If we need to make some configurations to the data base server, what :they are? : :3. A standard Unix ODBC client sounds a ideal solution for us. Is that :possible? Yes. Check out OpenLink's UDBC drivers which are in effect ODBC on Unix. This are also ANSI/CLI compatible. You do have to install one program on the Sun machine though, but that is a very simple install that requires no changes to the OS or database configuration. You simply copy the program to some directory, run the install script (which simply register your program, and does nothing to the OS). You might then want to do some changes to the request broker ini file. Thereafter you simply start this program, and make sure it is restarted if the machine is rebooted. On the client (HP) you then have a library to write to. I don't know anything about installing this, but it is probably quite simple. PS. I have *not* tested the UDBC client, so I can't tell you how well it works. Judging from the other products of OpenLink it ought to work well though. 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