Re: Web-based client for Informix 5.x

You could use OpenLink's Virtuoso to connect to multiple databases. Please visit http://www.openlinksw.com to download. General Information: Virtuoso is a revolutionary, next generation, high-performance virtual database engine for the Distributed Computing Age. It is a core universal data access technology set to accelerate our advances into the emerging Information Age. Virtuoso provides transparent access to your existing data sources, which are typically databases from different database vendors. Through a single connection, Virtuoso will simultaneously connect your ODBC, JDBC, UDBC, OLE-DB client applications and services to data within Oracle, Microsoft SQL Server, DB/2, Informix, Progress, CA-Ingres and other ODBC compliant database engines. All your databases are treated as single logical unit. The full installation takes up less than 10MB of disk space. The actual database element takes up less than 5MB. Virtuoso currently supports Linux ("glibc2" and "libc5" based distributions), Windows 95/98/NT/2000, and UNIX (all flavors). There are plans to port Virtuoso to the OS390, OS400, VMS, and MacOS platforms subject to demand. -- Thanks, Edward A. Geddis Technical Support Consultant OpenLink Software http://www.openlinksw.com Making Technology Work for You Jonathan Leffler <jleffler@earthlink.net> wrote in message news:377450F4.4E0C@earthlink.net... > Tan Wee Yeh wrote: > > I'm helping a friend code up a web-based client for Informix > > Online 5.x database backend. This project is really getting on > > my nerves because I do not have access to any Informix5 database > > so left almost everything on assumption. I based my coding on > > DBI/DBD::Oracle (which I am familiar with) hoping that > > DBD::Informix will be the same (fingers crossed). > > MOre or less. As long as you stick with ANSI SQL data types and > SQL statements, you should be OK. The Oracle extensions are generally > incompatible with Informix, and vice versa. That requires you to have > some insight into what is standard and what is not, of course. > > > Unfortunately, I am unable to compile DBD::Informix due to the > > required server. I did get my hands on the C-SDK but the version > > is 7.2UC3. > > Are you saying you didn't manage to get DBD::Informix to compile > with CSDK or ESQL/C, or that you haven't been able to get a 5.x ESQL/C > and/or server to match what your friend has? If it is the latter, > then it is reasonable - 5.x is getting towards the end of its life > and may not be available to new customers. If it is the former, > I want to know the details of the failure, per the instructions > in the README file. > > If you can get the 7.2x stuff to work, you can do 90% of your testing > with the newer system. It will only cause you problems if you try > to revert to the older software and use features which were not > supported in the older version. The most significant such feature > would probably be the CONNECT operation, which in 5.x is not available. > It is mimiced by using a DATABASE statement, but you cannot specify > the user name or password (or rather, they are totally ignored if > you specify them). > > > Here are several ventures I am looking into... > > - Does anyone have DBD::Informix compiled that will work with > > Informix5? Jonathan Leffler was of great help here when he > > gave me the assurance that it will work with the correct > > version of C-SDK. :). btw, is there such a version for Linux > > (intel)?? > > On which platform? Probably not, but ... > > > This will allow me to test my codes on my friend's client's > > site so I can recommend the purchase. > > > > - Is there any ODBC drivers that works with Informix? If so, I > > can still use my codes but link them to DBD::ODBC instead. > > Here, I'm looking into the drivers from openlinksw. > > In general, yes, but possibly not for 5.x servers. The ODBC > drivers would most likely be for 7.2x or later. > > > - As the final resort, is it possible to maintain an online > > data-replication between Oracle and Informix? > > Probably not. There might a 3rd party product that can help, but > most likely not. > > -- > Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) > Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN > #include <disclaimer.h> >