Re: ODBC - some observations

Hi Robert, Robert Lore <rlore@ozemail.com.au> wrote in article <55sflj$31t@reader1.reader.news.ozemail.net>... > Hello, I am posting this for people who are interested in using ODBC > for Informix. > > First some golden truths.. > 1. Forget about Informix I-Net product. Its useless (sorry). It > has a large memory footprint, is difficult to set up and is slow > and is expensive. And also it only works with Informix! > > 2. For get about Intersolvs Q+E or whatever it is called. Its > bloody expensive and performance is slow and also uses lots of > memory. I could continue here but I tried this product a few years ago > and threw it out way back when we were in the evaluation stage. > > There are two products which I know of, both by English companies > (co-incidence ?). One is called SQL-Retreiver, by VisionWare, > (who also do a very good X-windows on Microsoft Windows), and > OpenLink by OpenLink Software. We use SQL-Retriever. I reviewed > OpenLink and decided against it. > Fine, that was your choice and you are entitled to it. > I have been using SQL-Retreiver for three years now and have implemented > it in three large sites. The first is the Indonesian stock exchange > in Jakarta and Surabaya. Here they have about 5000 online users > using Informix OnLine 6.x with pc's running Windows for Workgroups > The client side code was done in VB3.0, and is being updated to VB4. > Three largish HP boxes run this and they are configured as a live > box, a hot backup and a referee. The middle tier has several smaller HP > boxes running the enquiry servers. These machines all run HP-UX 10. > OpenLink software has 20 - 30,000 users concurrently using its drivers at Xerox Corporation, the great thing is that this installation isn't an aberration, we have more than 2,500 companies (not licences) working post pilot with ODBC at the Enterprise level with lost of concurrent users. > The other installations are the Sun Alliance group, and the ING Bank > in Sydney. The machines used here are SUN Sparcs, Pc's runnig SCO Unix > and HP. SQLR also works over a phone line and does this quite well > over the poor quality lines in Indonesia. > Xerox, AT&T, Lucent, NCR, ALCOA, South Western Bell, BellSouth, Sprint, MCI, PG&E, Merrill Lynch, Barclays Financial Services, British Telecom, Morgan Grenfell, Salomon Bros., Lehman Bros, Robert Fleming, Applied Material, should I go on ??? The key message is than in many of these cases OpenLink was chosen over all comers in the ODBC space and for good reason :- 1. PERFORMANCE 2. SECURITY 3. INFRASTRUCTURE MANAGEMENT 4. ODBC FEATURES > Robert Lore, > DATATREE Computing Systems Pty Ltd > > NOW LETS GO WHERE NO OTHER DRIVER WILL GO : FULL BI-DIRECTIONAL SCROLLABLE CURSORS FOR INFORMIX & OTHER DBMS ENGINES !! We have done it, it works, it will be on the Web for the world to Enjoy during the next 14 days, with or without I-Net. I will expand on any of these issues should anyone require me to do so with nothing but pure simple technical facts as opposed to innuendo ! -- Best Regards, Kingsley Idehen President & CEO OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers