Professional Web Applications Themes

Web Server connecting to Informix Server - Informix

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 ...

  1. #1

    Default Web Server connecting to Informix Server



    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 doentation 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
    Wilson, John Guest

  2. #2

    Default Web Server connecting to Informix Server



    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 doentation 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
    Wilson, John Guest

  3. #3

    Default Re: Web Server connecting to Informix Server

    This should work fine, do the esql demo programs compile OK, if they
    do then the following scripts should give you a fully working
    apache/ssl/php installation, or at least it does on our Sun servers

    #! /bin/ksh

    APACHEDIR=apache_1.3.27
    MODSSLDIR=mod_ssl-2.8.14-1.3.27
    OPENSSLDIR=openssl-0.9.7b
    PHPHOME=/usr/local/php
    WEBHOME=/usr/local/apache

    cd ${APACHDIR}
    ../configure --prefix=$WEBHOME --enable-module=so
    if [ $? != 0 ]
    then
    echo "Whoops: Apache"
    exit
    fi

    cd ../${OPENSSLDIR}
    sh config -fPIC
    if [ $? != 0 ]
    then
    echo "Whoops: openssl"
    exit
    fi
    make
    if [ $? != 0 ]
    then
    echo "Whoops: openssl make"
    exit
    fi

    cd ../${MODSSLDIR}
    ../configure \
    --with-apache=../${APACHEDIR} \
    --with-crt=${WEBHOME}/conf/ssl.crt/server.crt \
    --with-key=${WEBHOME}/conf/ssl.key/server.key

    cd ../${APACHEDIR}
    SSL_BASE=../${OPENSSLDIR} \
    ../configure \
    --enable-module=ssl \
    --enable-module=so \
    --prefix=${WEBHOME}

    make
    make install

    cd ../${PHPDIR}

    INCL=/usr/local/include ./configure \
    --enable-track-vars \
    --with-informix \
    --with-openssl=shared,/usr/local/ssl \
    --with-imap \
    --with-imap-ssl=shared,/usr/local/ssl \
    --enable-safe-mode \
    --prefix=${PHPHOME} \
    --with-apxs=${WEBHOME}/bin/apxs \
    --enable-trans-sid \
    --enable-inline-optimization

    make
    make install



    "Wilson, John" wrote:
    >
    > 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 doentation 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
    --
    Paul Watson #
    Oninit Ltd # Growing old is mandatory
    Tel: +44 1436 672201 # Growing up is optional
    Fax: +44 1436 678693 #
    Mob: +44 7818 003457 #
    [url]www.oninit.com[/url] #
    Paul Watson Guest

  4. #4

    Default Re: Web Server connecting to Informix Server


    One easy way is to use java to connect ( java driver for informix is
    free - ifxjdbc.jar ).

    If you want, you can get the relevant information here -
    [url]http://www-3.ibm.com/software/data/informix/pubs/library/[/url]

    Rgds
    Preetinder

    Wilson, John wrote:
    >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 doentation 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
    preetinder dhaliwal Guest

  5. #5

    Default RE: Web Server connecting to Informix Server


    John

    Assuming you have IDS running on your web server you don't need anything
    else to communicate between the two engines apart from setting up the
    sqlhosts, /etc/services and .rhosts (/etc/hosts.equiv) files. You can then
    update any tables from either engine. (Both databases need to have the same
    logging state).
    To make names easier you might want to use synonyms or views.

    Keith

    -> -----Original Message-----
    -> From: Wilson, John [mailto:JWilson3troy.k12.mi.us]
    -> Sent: Wednesday, September 03, 2003 5:31 PM
    -> To: [email]informix-listiiug.org[/email]
    -> Subject: Web Server connecting to Informix Server
    ->
    ->
    ->
    -> 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 doentation
    -> 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
    ->

    ************************************************** ********************************
    This message is sent in strict confidence for the addressee only. It may
    contain legally privileged information. The contents are not to be disclosed
    to anyone other than the addressee. Unauthorised recipients are requested
    to preserve this confidentiality and to advise the sender immediately of any
    error in transmission.
    This footnote also confirms that this email message has been swept for the
    presence of computer viruses, however we cannot guarantee that this message
    is free from such problems.
    ************************************************** ********************************
    sending to informix-list
    Simmons, Keith Guest

Similar Threads

  1. Replies: 0
    Last Post: October 1st, 06:15 PM
  2. Informix CLI userthreads on server
    By Klaus Blumenstein in forum Informix
    Replies: 2
    Last Post: October 1st, 05:54 AM
  3. Replies: 0
    Last Post: August 18th, 04:42 PM
  4. Replies: 0
    Last Post: August 14th, 05:35 AM
  5. Informix 7.3 & W2000 Server
    By Sathyanesh Krishnan in forum Informix
    Replies: 0
    Last Post: August 4th, 05:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139