Web Server connecting to Informix Server
Posted in 2003
I am running an OLTP system with Informix 7.3 IDS on HPUX. We are considering writing some web interfaces to connect to the database. At first we mirrored the database tables to a web server so that no one was ever touching live data. This was relatively easy, just do a nightly export/import to the web server. However, we now wish to create some "updating" web pages that will connect back to the server. On the web server I am using PHP/MySQL/Apache for web development with the Slackware Linux v 9.0 (Linux 2.4.7) distrobution. I have tried multiple times to install the Linux Client-SDK hoping that somehow I could make a ODBC connection back to the Informix server. I have not yet been successful. I found a company that makes an Informix ODBC driver. I was unsucessful at getting it licensed for a 30-day trial. I tried compiling informix libraries into PHP, but ESQL doesn't seem to be compatible with gcc. What is the best way to connect the Linux web server to the HPUX Informix server? Can anyone point me to documentation on how to do this? I would RTM if I could find one. Any tips, links, articles, etc would be appreciated. John Wilson Administrative Systems Specialist Troy School District Information Systems sending to informix-list sending to informix-list