Re: VB4, Unix, ODBC and Informix

"Rod" <weirrj@ozemail.com.au> wrote: :Hello all VB developers. (V5 beta looks pretty good!) :I have recently been commisioned to upgrade a VB3 program that I wrote :using a JET 2.5 backend to a Unix-based Informix database. The four :letters ODBC come to mind. Has anyone had any experience along these :lines and have some tips and suggestions they would like to share? :What issues does working in the Unix environment present? :Any help is greatly appreciated. 1. Get rid of Jet (whatever version). Use RDO (remote data objects). You gain several times speed improvement and do not need to install the Jet engine at all. RDO works directly with the ODBC driver. This presupposed that you intend to upgrade to VB 4 (or better) and work in 32 bit mode (Windows 95 or NT). (But you wouldn't do anything else, would you?) 2. Make sure you use a high quality ODBC driver like i.e. OpenLink. This gives you high performance, security options and several other advantages. 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