Re: Connecting MS Access to Informix (how?? help, please !!)

infodata@batelco.com.bh (INFODATA) wrote: :Hi folks, : :I wish to talk to Informix database engine from a MS Access client :application. Here is my environment : : :Server: I-SE 7.20.UC4 on DEC ALPHA 4000 : :Client: MS Access 2.0 : MS Windows95 : I have I-Net PC 5.01 running on my clients ( not sure if this is :required though ....) : :I require an ODBC driver for the interface. The ODBC drivers bundled by :Informix dont seem to work. The documentation says that they are for :Informix client apps only, such as NewEra. If you have the Informix CLI product for Windows 95 that is their ODBC driver which you can use. This runs on top of I-Connect (formerly I-Net). You do need 32 bit versions of these of course. :Are there any ODBC products manufactured by Informix that can be used in :this case? Alternatively are there any suitable third-party ODBC drivers :available for this and how would one go about obtaining them? I'd truly :appreciate any help in this regard. The best ODBC drivers are available from OpenLink. Check out http://www.openlinksw.com You can download a trial version for free. Make sure you get the server based drivers (*not* the lite version that requires I-Net/I-Connect to be installed on your PC). These drivers are fast, easy to install and have all the functionality that an ODBC driver realy must have, including security options. Do read their white paper on ODBC that's available on their web site. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org