I just want to connect my Informix 9.21 and Baan IVc4 into ODBC using a Microsoft Access 2000 database, i don't know what are the things that i must setup first, is there anyone who can help me?, a screenshots in the setting up of ODBC is a big help.

First I would suggest upgrading to the latest Informix 9.4 version. 9.21 reached its end of support on June 30, 2004.

You need to install the Client SDK for Informix on the same computer as MS Access. This can be downloaded from ibm.com or from your software installation cds.

Once that is installed, setup a new odbc connection (control panel - odbc) with the connection info for your database (server name, service name, db name, ...)

Use that connection is Access to retrieve data.

Andy