RE: Level 2 ODBC Drivers for IDS

Posted in 2003

Alexey Sonkin — Tue, 22 Jul 2003 11:41:41 -0400 — source: Usenet: comp.databases.informix

David, There is one more point in that 'ODBC Level 2 conformance' discussion. It is very simple for the "Tools" vendor to say 'we require Level 2 ODBC'. I don't believe that they really use ALL Level-2 functions. It might happen that ODBC functions missing in Informix ODBC (You can get list of them in the Manual) are not actually used by particular tool. You can send the 'tools' vendor a list of missing functions and ask "Do You really need them? Or: What functionality of the "Tool" I'll loose without this function?" ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: David E. Grove [mailto:david_grove@correct.state.ak.us] > Sent: Friday, July 18, 2003 7:14 PM > To: informix-list@iiug.org > Subject: Re: Level 2 ODBC Drivers for IDS > > That sure makes sense, Alexey. > > So, it would seem that IBM does not supply a Level 2 ODBC driver. (The > list > of unsupported ODBC features in the manual confirms it.) Further, IBM > says > that theirs is the only ODBC driver they recommend. > > That suggests two questions: > > 1) What is IBM's solution to the need for a Level 2 ODBC driver? > > and > > 2) What are other users doing to get ODBC Level 2 conformance? > > DG > > > > > > "Alexey Sonkin" <alexeis@grandvirtual.com> wrote in message > news:bf9t1f$fhl$1@terabinaries.xmission.com... > > > > Hi, David, > > > > I think that IBM engineer's confused between ODBC level > > and ODBC version. > > "new Informix product that implements the Microsoft Open Database > > Connectivity (ODBC) version 3.0 standard" (from Release notes) > > > > ------------------------------------------ > > Alexey Sonkin > > Senior Database Administrator > > > > > > > -----Original Message----- > > > From: David E. Grove [mailto:david_grove@correct.state.ak.us] > > > Sent: Friday, July 18, 2003 3:38 PM > > > To: informix-list@iiug.org > > > Subject: Re: Level 2 ODBC Drivers for IDS > > > > > > IDS 9.21.FC4-1 > > > Solaris 8 > > > Wintel client machine > > > > > > We want to use the AcuCorp AcuCobol product. We ran its ODBC Driver > test > > > program, and it reported that our ODBC driver (3.82.0000 2.81.TC1) was > > > Conformance Level 1 (both SQL and API). Since AcuCobol requires Level > 2, > > > I > > > called IBM tech support to inquire on availability of Level 2 ODBC > > > drivers. > > > They told me two things: 1) the current IBM driver is the ONLY > > > recommended/supported driver-- any 3rd party product is unsupported > and > > > used > > > at our risk; 2) the current IBM Informix ODBC driver is ODBC Level 3 > > > compliant. > > > > > > I am aware of ODBC Level categories (API and SQL) of "Core", "Level > 1", > > > and > > > "Level 2". I am not aware of "Level 3". I asked the engineer if > Level > 3 > > > was a superset of Level 2. He didn't seem to fully understand the > > > question, > > > and told me that it didn't really matter because the IBM Informix ODBC > > > driver was the only recommended driver, regardless. I replied that > > > Acucobol > > > requires a Level 2 driver, and wanted to know if the IBM Informix > driver > > > qualified as Level 2. The engineer again replied that it didn't > really > > > matter because the IBM Informix driver was the only recommended > driver. > > > At > > > that point, it seemed like we were in a rut, so I thanked him for his > time > > > and politely ended the conversation. > > > > > > But, I am still confused and a little frustrated. > > > > > > Does the IBM Informix ODBC driver conform to Level 2 (SQL and API)? > > > > > > Is there really an ODBC "Level 3" Conformance rating? > > > > > > Is it really true that the only workable IBM Informix ODBC driver is > the > > > one > > > that is published by IBM? > > > > > > > > > Thank you. > > > > > > DG > > > > > > > > > > > > "David E. Grove" <david_grove@correct.state.ak.us> wrote in message > > > news:vhg99sc8ankb0@corp.supernews.com... > > > > Does anyone know if there exist any Level 2 ODBC drivers for > Informix > > > 9.x? > > > > > > > > We are using the latest IBM Informix ODBC driver (3.82.0000 > 2.81.TC1), > > > and > > > > it appears to be Conformance Level 1 (both SQL and API). > > > > > > > > Thank you. > > > > > > > > DG > > > > > > > > -- > > > > David Grove > > > > > > > > > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > > > - > > > > "I think not," said Descartes, and disappeared. > > > > > > > > > > > > sending to informix-list sending to informix-list