Re: Connect CA Openroad to Informix DB

Michael Buchberger wrote: > > Hello everybody, > > we intend to connect an CA OpenRoad application, developed under > MS Windows 3.11, to an Informix database, running on an Dynix or > SCO database server. The applications is now running with an Ingres > database on an AIX server and we do not like to modify all the > statements written for this architecture. > > So, do you have any experience with ODBC drivers or gateways or > something like this in this context? > > bye > Michael > > -- > Michael 'Lefty' Buchberger Am Jagdstock 35 76829 Landau Germany > Compuserve 100736.443 lefty@animator.pfalz.de We have recently completed porting a large OR/ESQL application from INGRES to Informix. We investigated many different approaches and decided that the best solution was to use the CA gateway to Informix. Like you we were reluctant to carry out large scale modifications to the application software and this method best satisfied that need. We had the additional requirement that the application still had to run against an INGRES database consequently we wanted to minimise the amaount of database specific code. The only disadvantage at the moment is that the gateway is currently beta software and is only available on the IBM RS6000 machine. When the gateway will go GA and on what platforms I do not know however presumably CA will be able to inform you of this. Our experience to date has been reasonably good; the main area of change was in converting the SQL from INGRES/SQL to INGRES/OpenSQL, in the 4GL this was relatively easy. The main problem area (suprise, suprise) was in the handling of the different date formats. In general I would say that (for us certainly) converting an application from Ingres to Ingres/Informix was pretty painless. HTH -- Kevin Hogarth | (the opinions expressed are my own) Architecture Group | British American Consulting Group | Phone: (+44) 0113-259-5220 Enterprise House | Fax: (+44) 0113-259-5150 1, Apex View | Email: kevinh@dial.pipex.com Leeds LS11 9BH |