Re: ODBC and NewEra

Posted in 1997

Tom Beuke — 30 May 1997 09:51:00 +0200 — source: Informix-list mailing list archive (1991-1998)

In article <338d9dec.10590199@news.innet.be>, cvandecasteele@tis.be (Carl Van de Casteele) wrote: > Is it possible to query an Oracle db from within a NewEra program via > an ODBC data source ? Is it necessary to use the Oracle ODBC driver > provided on the NewEra CD ? We've experienced that the best ODBC-Drivers for use with NewEra are the ones from INTERSOLV. Except for a bug in ixSupertable::buildselectstmt() which produces non-odbc-conformant statements (can be easily corrected by manipulating the created ixString-variable) this combination works fine for us. In my opinion this is even faster than connecting to an Informix- Datebase over INFORMIX-NET. > Can we use the Microsoft provided ODBC driver to query dBase IV files > from within NewEra ? We tried running our application with Foxpro-datafiles over ODBC. It worked but the performance was getting inaccectable with datafiles containing more than 500 entries. -- t_beuke@tob.prima.ruhr.de