Re: Informix SE and Access

"Pat O'Connor" <poconnor@internetmci.com> wrote: :I hope that this is easy - :We have this software installed on (3) Intel boxes running SCO Unix :3.2.4.2: : SE 4.11.UC1 SQL 4.11.UC3 GL 4.11.UC4 ID 4.11.UC4 :Multiple 4GL applications running on multiple databases. :All managers have moved to WIN95 with Office 97. :Managers want to open Informix databases under Access run run querries and :create reports. :Questions: :1. What needs to be done to the Informix products? Nothing. :2. Does anything need to be done to the SCO (managers are now 'telnet'ing :to these boxes). Install an ODBC server component from one of the suppliers of these (http://www.openlinksw.com and http://www.vision.sco.com are two). :3. Is there any additional software needed? Install the ODBC client component from the same manufacturer as the server component on the MS Windows PC's. We use the OpenLink version. It has functionality to implement some security features you may want. They both have trial versions on their web pages. In MS Access you can simply connect to the Informix tables and start doing queries directly on them. Do read the white paper on ODBC on the OpenLink web site. It gives you a lot of valuable information on ODBC, its problems and oportunities. 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