Re: Wanted: Fast ODBC connection

Rainer Nasch <nasch@informatik.uni-osnabrueck.de> wrote: :We work with Intersolv odbc32 (Vers. 2.12 and 3.0). : :But the performance between MS-Access and Informix 7.12 SE (AIX) is an :any way inacceptable! : :Who has better experience and might give me some hints for better :configuration (or where to find some)? : :Thanks :Rainer Nasch :(Please email me) This depends on many variables: 1. How you use MS Access: It isn't usefull for much but add hoc query and updating and used as a report writer. You will be dissapointed if you use it for developing applications. 2. What version of MS Access you are using: I think, but am not 100% sure, that the very latest version (the Office 97 one) can use ODBC direct which is much faster. 3. Your ODBC driver: Download and install the free trial version of OpenLink and see what happens (http://www.openlinksw.com). Make sure you donwload the server based version, not the Lite version that use I-Net/I-Connect. 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