Re: Online 4.0 and ODBC
radreste@cyber1.servtech.com (bob dreste) wrote: >Our company has been using an application written in Informix Online version >4.0 running on an HP 9000. We have written numerous 4GL and ACE programs to >satisfy one-off user requests for reports that are not in the system we >bought. The problem is, once you start doing this it never stops. These >reports are usually kicked off via a cron or a user logging in and running >them. I really would like to see the whole thing put to bed by using a >client server ODBC approach. Everyone in the company has access to >Microsoft Windows in a Novell Lan environment. We also do a considerable >amount of TCP/IP and FTP communications using Reflection. My question is >Do we need to upgrade to Version 5.0 of Informix to use ODBC? If so, what >is the ballpark price ? Also, what is the most preferred way of using ODBC >from a PC based windows machine? I've seen some mention in this newsgroup >of Visionware etc. Thanks for any responses . Bob, I'm not aware that you have to upgrade to V5 for ODBC, you just need I-STAR on your HP. Depending on your ODBC driver, you may need I-NET on the client PC's and I'm not sure that Reflections TCP is supported - you may need to get PC/TCP or SunSoft PC/NFS. I'm sure that the ballpark price is starting to look a little less appealing, but who knows? :) I don't know if there is a most preferred way of using ODBC - the vendors all have their merits (and demerits! :) I would advise you consider going to V7.1 (a big jump, I know), because I've heard rumours that 7.x is going to be the minimum product level in a while (probably a long while :) (This is *all* IMHO) HTH. -- Cheers, Billy ----------------------------------------------------------------------------- INCLUDE "Disclaimer.4gh" -- my opinions are INCLUDE "FlamesToDevNull.4gh" -- flamers, eat my shorts! INCLUDE "CaveatEmptor.4gh" -- take my advice at your own risk INCLUDE "ThirtySomething.4gh" -- header file for this class -- Written by : Billy Wheeler, Date: today -- Copyright (c) 1995, The West Solutions Group