Re: Using 6.x tools with 5.x SE

}From: rferdy@kuwait.net (Rudy Fernandes) }Date: Tue, 17 Dec 96 07:22:19 GMT }X-Informix-List-Id: <news.31753> } }We are shortly going to be upgrading our 4.x tools to 6.x, }and our 5.x SE to 7.x Online. } }Our site has multiple databases - one mediumish, the others small, all }important. } }>From what I've gathered about ONLINE through reading the System }Admin manual, it appears that there is a large, fairly constant, }amount of intervention required to keep it going smoothly. } }To reduce my transition headaches, I was considering keeping both }SE and ONLINE running and transiting to ONLINE, one database at a time, }starting with the big one. } }I do not want to do the same for the tools, though. } }I'd be grateful if somebody can help me with the following:- } }1. Can a 4gi compiled on 6.x tools work with 5.0 SE? What I'm about to say will probably work, but will probably not be supported. If you don't like that, don't do it, or check with Informix Technical Support to see whether it is supported. Yes. You have to run an sqlexecd process for the 5.0x SE system, I think. You create the 6.0x $INFORMIXDIR/etc/sqlhosts (or $INFORMIXSQLHOSTS) file with an entry for the name of the SE system, a network connection, the appropriate host and service name. You should then be able to connect to the SE database setting the INFORMIXSERVER variable to the name of the SE system. Basically, you have to make the 5.0x SE look like a 6.0x or later database server. }2. If so, if the 4gl is compiled using the 5.0 SE database, will } it run on the ONLINE db? Or do I need to recompile? If the schema is the same in SE and OnLine, then you don't have to recompile. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>