Oninit cdi / Archive
Talk to an expert →

RE: sort with access program is not working

Posted in 2005

Topics: Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Platform-Specific Issues

Tsutomu Ogiwara — — source: Usenet: comp.databases.informix

Hi Muthana. Probably, you hit the following problem. 167548 ERROR 309 FROM MSACCESS WHEN LINKING A TABLE WITH AN UNIQUE INDEX AND AN ORDER BY Contact IBM support. Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: <Muthana.AL-Temimi@tu-harburg.hamburg.de> >To: <informix-list@iiug.org> >CC: <moltrecht@tuhh.de> >Subject: sort with access program is not working >Date: Mon, 7 Feb 2005 16:31:14 +0100 > > >Hello there, > >I have the following Problem and I need tips to solve my current >problem. >I tried separately: > >1. CSDK2.81.TC1 >2. CSDK2.81.TC2 >3. CSDK2.81.TC3 > >and I found that the query with MS-Access program will not work >correctly and here is the query: > >SELECT soshh_lab.mtknr, soshh_lab.pnr >FROM soshh_lab >WHERE (((soshh_lab.mtknr)=27255)) >ORDER BY soshh_lab.pnr;> >And I got the following error: > >ODBC-Error >[Informix][Informix ODBC Driver][Informix]ORDER BY column (pnr) must >be in select list. (# -309) > >I did and tried the same SQL direct into the DB using ISQL --> it works. >But if I use the same query within MS-Access Program and I alliance my >table through ODBC. I get always the ERROR just as written above. > >I tried the same query but without order by it will be works fine. But >the sort it will not work. I think my problem is with the CSDK and I >need to solve this problem. > >My environment on Linux Debian: > >ISD: 9.30.UC3 >4GL: 7.32.UC2 >ISQL: 7.32.UC2 > >Can somebody help me on this? > >Regards >Muthana > > sending to informix-list

↪ replying to Tsutomu Ogiwara
Richard Spitz — — source: Usenet: comp.databases.informix

"Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> schrieb: >Probably, you hit the following problem. >167548 ERROR 309 FROM MSACCESS WHEN LINKING A TABLE WITH AN UNIQUE INDEX AND >AN ORDER BY > >Contact IBM support. And what will IBM support do? I'm asking because we are facing an update from Access 2000/Connect 2.70TC3 to Access 2003/Connect 2.81TC3 and would like to know in advance what problems to look forward to. Regards, Richard

↪ replying to Richard Spitz
Gary Quiring — — source: Usenet: comp.databases.informix

On Tue, 08 Feb 2005 14:09:10 +0100, Richard Spitz <Richard.Spitz@med.uni-muenchen.de> wrote: >"Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> schrieb: > >>Probably, you hit the following problem. >>167548 ERROR 309 FROM MSACCESS WHEN LINKING A TABLE WITH AN UNIQUE INDEX AND >>AN ORDER BY >> >>Contact IBM support. > >And what will IBM support do? > >I'm asking because we are facing an update from Access 2000/Connect 2.70TC3 to >Access 2003/Connect 2.81TC3 and would like to know in advance what problems to >look forward to. > >Regards, Richard I have recently contacted IBM about this issue and they still do not have a fix. The latest version they gave us was 2.9TC1 which is still broken. I have a demo license from OpenLink and DataDirect that are working fine with MS Access. My only issue with OpenLink is their drivers are broken if you need to access a 7.x and 9.x engine in the same query. Gary Quiring

↪ replying to Gary Quiring
Richard Spitz — — source: Usenet: comp.databases.informix

Gary Quiring <gquiring@msn.com> schrieb: >>>Probably, you hit the following problem. >>>167548 ERROR 309 FROM MSACCESS WHEN LINKING A TABLE WITH AN UNIQUE INDEX AND >>>AN ORDER BY >>> >>>Contact IBM support. >I have recently contacted IBM about this issue and they still do not have a fix. >The latest version they gave us was 2.9TC1 which is still broken. What about the recently released version of CSDK 2.90? Is the problem fixed now, or did anybody receive a patch from IBM support that solves this bug? Regards, Richard

Related threads

Glossary