Re: Informix ODBC Drivers Help
In article 7102@praxis.co.uk, jacko@praxis.co.uk (Richard Jackson) writes: ]Hi, ] ]A short while ago I asked which vendors I could get an ODBC driver to ]link an Access front-end application to an Informix back-end RDBMS. ] ]I received a number of replies, of which these were the companys and products ]mentioned the most : ] ]1) Intersolv (Q+E) ]2) Informix NewEra ]3) VisionWare - SQL-Retriever ]4) OpenLink Software - OpenLink ]5) TechGnosis - SequeLink ] ] ]I would like to know which of these products to avoid and which ones ]to consider as I have no prior knowledge of any of these - so any kind of ]information would save me from going down the wrong path. ] ]Thanks in Advance ! ] I thought this might be of interest, so I posted this here... We are currently trialling SQL Retriever (VisionWare) as an ODBC solution. It comes in two parts - the PC based part, and the host based part. The PC based part can talk to multiple hosts, and the host does not have to be running an Informix database - VisionWare can supply drivers for Oracle, Sybase and Ingres to name a few. This ability is of interest to us, as we currently run Informix and Ingres (don't ask me why!) and are installing a system based on Sybase. If we convert a database to run under a different vendor's engine, we don't have to change SQL Retriever - just tell it that there is a different engine supplying the data. I advise being careful on which version you get. We had quite a few problems installing some versions. We are currently trialling version 3.1.900.0 (well, that's what it reports), which installed without any hassles, and runs fine. - Ben Kelley --- This e-correspondance is PostcardWare (tm). You are hereby granted the licence to view, read, and otherwise inwardly digest this message for 14 days, after which, for continued use, you should register by sending a post card to the address below. Registration entitles you to free email support in understanding future signatures. Ben Kelley - SBC Australia, PO Box N100, Grosvenor Pl, Sydney, 2000, Australia (e-postcards to ben@syd.au.swissbank.com) Ph +61 (0)2 258 2382