Re: Linux + esql/c

Nick Holmes said to WinNT; I >I have a situation where I need a Linux (redhat5) webserver to connect >to a Sco 3.2/informix 7.2 database back-end system. > >I am intending to use Perl and the DBI/DBD driver for informix, which I >understand requires esql/c to compile the data-access routines - which >seems logical. The problem that I am having at the moment is installing >esql/c - it seems to require some of the informix database >headers/libraries in order to install - which kinda makes a client >install difficult. > >does anyone know how I should best go about installing esql/c under >these circumstances. Don't. Precompiled libraries have all kinds of dependencies on the environment they were compiled against. Unless you compile and link in their native environment you can expect show stopping problems. There are three solutions: 1. Call Informix, tell them you want ESQL/C, you want it *now* and why the hell they haven't got their act together *yet*. 2. Get QueriX, rewrite the DBI/DBD driver to use QueriX C SQL routines (actually QueriX is a 4GL clone but the C it generates is lovely and straight forward to write yourself). QueriX has a native Linux version :-). If you did 1 above call Informix back and tell them thanks but you've found a competitor that *can* deliver :-). 3. Build Perl on SCO with the standard DBI/DBD driver (linking statically so you don't need shared libraries). Copy the resulting binary to Linux and use for Perl scripts that need to talk to the Informix engine. Make sure you have an up to date iBCS module installed on Linux and SCO binaries "just work". (Or if they don't, I want to know what's going wrong so it can be fixed :-) ) Whatever, call Informix and point out to them that their policy of concentrating on engines is making it rather difficult for you to actually *use* their DB after you've installed it... Mike -- .----------------------------------------------------------------------. | Mike Jagdis | Internet: mailto:mike@roan.co.uk | | Roan Technology Ltd. | | | 54A Peach Street, Wokingham | Telephone: +44 118 989 0403 |