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

Try the Intersolv DataDirect ODBC Drivers. They are located in Rockville, MD (301)838-5000. We are using it successfully with On-Line Version 5 and MS Access 2.0 under Win 3.1. I have no idea how it will work with Win95. We are testing the WinNT version now. Unfortunately, it is not as fast as running queries on the UNIX box, but you have the benefit of using MS Access or VB applications as a windows front-end. The speed is not unreasonable especially if you use the "pass through" query option and try to optimize your datasets and queries. One drawback is that you can't use Informix Temp tables to speed data access (or at least we haven't figured a way) or multiple SQL statements as you can in DBACCESS. Mitchell Gaines mgaines@milbank.com >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. >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. >Thanks in advance, >Sandeep Soneja