Re: ODBC drivers for Informix
>>I'm looking for ODBC drivers for Informix, any suggestions would be >>greatly appreciated! Thanks. Exerts from the Informix FAQ! ---------------------------- 0.2 HOW CAN I GET THE LATEST COPY OF THE FAQ? 0.2.1 anonymous ftp The latest version of this document can be retrieved via anonymous ftp. The plain-text version is available as informix.faq.Z and informix.apx.Z HTML versions can be found as informix.faq.html.tar.Z and informix.apx.html.tar.Z o kcbbs.gen.nz in the "informix" directory o mathcs.emory.edu in "/pub/informix/faq" You can drop the .Z suffix if you want an unCOMPRESSed files. 0.2.2 World Wide Web USA: http://www.garpac.com/informix.html (Contact clay@panix.com (Clay Irving)) EUROPE: http://linux3.cc.kuleuven.ac.be/~bert/ (Contact Bert.Barbe@linux.cc.kuleuven.ac.be) 0.2.3 comp.databases.informix I hardly ever post the FAQ to c.d.i. because it's rather large and so annoys those people who receive c.d.i. via the mailing list. 0.2.4 email If you don't have access to FTP try using a FTP-by-mail server. Send a message with "help" in the subject line to the nearest one of: o ftpmail@decwrl.dec.com o ftpmail@sunsite.unc.edu o ftpmail@doc.ic.ac.uk o ftp-mailer@informatik.tu-muenchen.de o ftpmail@grasp.insa-lyon.fr o ftpmail@cs.uow.edu.au 6.3 Where can I get an ODBC driver? * Q+E Software provide the most well-known ODBC interface to Informix (I think Q+E are an "InSync" Informix partner), but seem to be the most maligned on c.d.i. - if only because it needs I-NET and I-Star, and so is the most expensive. * Visionware have a product, SQL-Retreiver which does *NOT* require I-NET on your PC, More information from info@visionware.co.uk. Is quite cheap but it implements almost no level 2 ODBC API calls (which you probably don't need) * VMARK software have HyperSTAR, which runs under SCO Unix. More information from lgz001@aol.com (Larry Zechter) * EDA/SQL from Information Builders * SequeLink from Techgnosis * DAL Server for Unix from Pacer Software. More information from pgk@pacersoft.com (Paul Kamp) * OpenLink Software have ODBC drivers for Informix S.E/Online 5.x,6.x,7.x. This product does NOT require I-NET on the PC. More Information can be obtained from the following sources ;- Compuserve; GO WINAPF Compuserve Mail : 72662,3403 Email: 72662.3403@compuserve.com Fax: ++44-81-681-7702 Tel: ++44-81-681-7701 * There is also a solution from Gupta Here's some observations about various ODBC drivers from Robert Lore: From: rlo@fmsc.com.au (Robert Lore) Date: 29 Nov 1994 00:03:10 -0500 So you also found that Q+E is [expletive deleted]! There are two products, 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. VisionWare's SQL-Retreiver has some minor problems, insofar that it leaves around dead SPL processes on the server causing Informix to forbid more logins because it thinks there are already too many people logged in. It will not return result sets from stored procedures. You can use sp's for insert, update and delete, however. OpenLink does not have these problems, it is faster. We are using both concurrently, and they co-exist without any problems. We are leaning toward going with OpenLink, and will retire the VisionWare after about another 4 weeks. We are a development house and our first live site using Informix will be January 1995 with a 100 user licence for the ODBC. If you are in a similar boat, you will find either product heaps cheaper cos. you don't have to pay USD$300.00 for each pc to have I-NET and Q+E, or I-Star for the Server. Both products remove this requirement, they use remote procedure calls (RPC's). Also either of these products is heaps faster than Q+E, flames invited, we have tried all three, so there! Both are priced very similarly. In both instances their technical suport is excellent, you will speak to the people who work next to the ones who wrote the stuff. Have fun, Robert Lore +--------------------------------------------------------------------+ | Scott Allred Internet: scott.allred@nsc.sprint.com | | Sprint/North Supply AOL: kujaahawk@aol.com | | New Century, KS MSN: kujayhawk@msn.com | | USA Phone: (913) 791-7000 x1810 | | Fax: (913) 791-7671 | +--------------------------------------------------------------------+