Re: -MAJOR- ODBC order by bug?

Jay Hannah <jay@jays.net> wrote: >Greetings -- > >I just tried Intersolv's latest ODBC drivers: >INTERSOLV 3.10 32-BIT INFORMIX > >This driver suffers from the exact same problem as ver 2.50. > >I'll be fiddling with OpenLink's drivers over the next few days... > >Sigh, > >Jay > > >================= >Since my original post has expired from >my news server, here it is again: >================= >It seems to be impossible to sort on char (or varchar) fields via Access >97 / ODBC linked to Informix... > >-------------------------- >create table sorttest ( > col1 int, > col2 char(20), > col3 varchar(20) >); >insert into sorttest values (1, 'A', 'A'); >insert into sorttest values (2, 'B', 'B'); >insert into sorttest values (3, 'C', 'C');> >[ Now, in Access 97: ] > >SELECT col1, col2, col3 FROM sorttest ORDER BY col1;> Works fine... > >SELECT col1, col2, col3 FROM sorttest ORDER BY col2;> [INTERSOLV][ODBC Informix driver][Informix] ORDER BY column > [col2] must be in SELECT list. (#-309) > >SELECT col1, col2, col3 FROM sorttest ORDER BY col3;> Same error... > >SELECT sorttest.col2 FROM sorttest ORDER BY sorttest.col2;> Same error... > >SELECT sorttest.col2 FROM sorttest ORDER BY 1;> Same error... > >SELECT sorttest.col2 AS c2 FROM sorttest ORDER BY c2;> Prompts for c2 (useless)... >-------------------------- > >This is a DEVASTATING bug (unless I'm just being stupid). > >Any ideas? > > >DB-Access Version 7.20.UC5 >INFORMIX-CLI 2.5 (32 bit) 2.12.0000 (* AND 3.10!! *) >Microsoft Windows 95 4.00.950 (ODBC Data Source Admin 3.0.23.1) >Microsoft Access 97 >================= There is a Windows registry /ini setting for this version of the Intersolv drivers that will fix this problem. I can't remeber what it is, but if you call Intersolv tech support or go to their web site you will find it. ___________________________________________________________ Jay Aymond United Life & Annuity Insurance Company Email: jay@ulife.com