Interface MS-Access with Informix using ODBC.
Posted in 1994
Topics: Connectivity: ODBC / JDBC / .NET
What is your experience with MS-Access when used with Informix? Bad, good? What are the kind of problems do you have? I'd like to hear any experiences that you have with using MS-Access with Informnix connecting through ODBC driver. I'm using MS-Access 2.0 interfacing with Informix. I use I-net version 5.01 and Q+E ODBC driver. Over all, it's going very nicely, except for a couple minor problems. One of the problems is not being able to run queries on attached tables when there is no "connection established". That is, when a query on an attached table is run, on other databases like Oracle and Sysbase, it would ask you to login, but with I-net and informix, it just say that there is no connection, therefore it gives you a ODBC failure message. A work around it is to run a "pass-through" query to establish the connection first. Has anyone experienced the same problem? Any solution for it? Nguyen Nguyen Alert Centre, Inc