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