Re: Can ODBC work with Informix Online 5.0??

Yes! >From: Gary Wheeler <gwheeler@foxboro.com> >Date: Tue, 01 Jul 1997 17:26:30 -0400 >X-Informix-List-Id: <news.39961> > >Does anyone know if I can use ODBC to access an Informix 5.0 database? >I was told recently that ODBC was not implemented for Informix until >6.0. I suspect 7.x would be more accurate. >The person in question is no longer available, so I can't ask them if >they meant that Informix did not have their =own= ODBC drivers for >version 5.0 (but 3rd-party ODBC drivers were available) The Informix ODBC Drivers are known as Informix-CLI. >or whether they >meant that version 5.0 is simply not capable of being accessed via ODBC. I've been doing some forwards compatability testing with I-CLI 2.5 (which is compiled for use with 7.2x ESQL/C), so I have a good ODBC working environment. I have my .odbc.ini file set up with data sources for 9.12.UC1, 7.23.UC1 and 5.08.UD1 OnLine/IUS engines, and I can use the same program to connect to any of the three data sources. The only trick with ensuring that the 5.08 OnLine can be accessed is making sure that the 5.08 I-Net connection is working, and your sqlhosts file is set up correctly. >You see, we have the need to develop an application to access an >Informix 5.0 database, and have been "requested" to use ODBC to >accomplish this, if possible. I'd rather not spend much time >investigating this route if it's an impossibility, due to inherent >limitations in Informix 5.0. It is not inherently impossible. If your ODBC Driver is on a PC (rather than on Unix as I was testing), then you're into networking anyway, so the I-Net sqlexecd isn't a problem. You just have to work out how to configure ODBC and I-CLI on your PCs to talk to your OnLine server. Don't ask me! Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> PS: I decline to respond to messages with anti-spam in the return path.