Re: Can 4.0 SE & 7.1 SE coexist?
Posted in 1997
"Joe" <joe@colsys.com> wrote: : We have a client using Informix SE 4.0 on a SCO Unix system. They want to :access the database with ODBC, so they upgraded SE 4.0 to 7.12, which :includes Informix-Net. : :The problem is that their Unix application was written using the 4.0 tools :and hence needs to use the Relay Module (sqlrm) to run. They are :complaining that the application is now much slower, probably because of the :relay module. You should of course have upgraded the tools at the same time. You would of course have had to recompile the application. :My idea is this: On the Unix system, continue to use the SE 4.0 engine to :access the database, but still run the 7.12 sqlexecd so ODBC can be used to :access the database. This will avoid the relay module. However, it means :that both the 4.0 engine and the 7.12 engine will be accessing the same :database. : :We have not tried this yet, but could it cause problems (such as...)? This will *not* work as several have allready said. If you for some reason can't upgrade the tools and recompile the application you do however have another option. You can use one of the third party ODBC drivers that does not need or use I-Net. At least the OpenLink drivers does support the SE 4.0 engine on SCO. (See http://www.openlinksw.com) You also get the added benefit of a much better ODBC driver. Read their whitepaper. 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