RE: Level 2 ODBC Drivers for IDS
Posted in 2003
Topics: Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Platform-Specific Issues, Versions, Editions & End-of-Life
David, You can also investigate drivers from Intersolve, or whatever they call themselves nowdays (though, IBM doesn't recommend that) My own understanding is that some Level-2 ODBC features require curtain server-side features, that Informix doesn't support. ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: Martin, Wayne E. [mailto:WMartin@kmart.com] > Sent: Tuesday, July 22, 2003 8:13 AM > To: 'David E. Grove'; informix-list@iiug.org > Subject: RE: Level 2 ODBC Drivers for IDS > > Informix had ESQL/COBOL product at one time, not sure if it is still > around....... > > Wayne Martin > Database Administrator > Kmart Corporation > > > -----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 > > > > This message and its contents (to include attachments) are the property of > Kmart Corporation (Kmart) and may contain confidential and proprietary > information. You are hereby notified that any disclosure, copying, or > distribution of this message, or the taking of any action based on > information contained herein is strictly prohibited. Unauthorized use of > information contained herein may subject you to civil and criminal > prosecution and penalties. If you are not the intended recipient, you > should delete this message immediately. > > > > sending to informix-list sending to informix-list