Problem with ODBC and Access

i used CONNECT to access data from an IDS 7.30 UC-1 -Database. The server is based on SINIX 5.43C. i tried a simple query with order by one column (wgr). Sqlerr 309 was produced by the ODBC. Without ordering it was no problem. Does anyone have ideas. i copied the output from MSAccess and the output from the onstat-command on the unix-server. Based on the Server-command the sqlerr is right, but why is the statement different from the access-sql statement. Different count of columns in SELECT-list. Wrong: ACCESS-SQL-Statement ******************************* SELECT Best'nde.lo, Artikelstamm.wgr, Best'nde.artnr, Artikelstamm.bez1, Artikelstamm.bez2, Best'nde.bestand FROM Artikelstamm INNER JOIN Best'nde ON Artikelstamm.artnr = Best'nde.artnr WHERE (((Best'nde.lo)="CT") AND ((Artikelstamm.wgr)>20)); onstat -g ses - INFO: ************************* SELECT baum.ast.artnr, baum.abst.lo, baum.abst.artnr FROM baum.abst, baum.ast WHERE (((baum.abst.lo = 'CT' ) AND (baum.ast.artnr = baum.abst.artnr ) ) AND (baum.ast.wgr > 20 ) ) ORDER BY baum.ast.wgr right: ACCESS-SQL-Statement: ******************************** SELECT Best'nde.lo, Artikelstamm.wgr, Best'nde.artnr, Artikelstamm.bez1, Artikelstamm.bez2, Best'nde.bestand FROM Artikelstamm INNER JOIN Best'nde ON Artikelstamm.artnr = Best'nde.artnr WHERE (((Best'nde.lo)="CT") AND ((Artikelstamm.wgr)>20)) ORDER BY Artikelstamm.wgr; onstat -g ses - Info: *********************** SELECT baum.ast.artnr,baum.abst.lo,baum.abst.artnr FROM baum.abst,baum.ast WHERE (((baum.abst.lo = 'CT' ) AND (baum.ast.artnr = baum.abst.artnr ) ) AND (baum.ast.wgr > 20 ) ) ORDER BY baum.ast.wgr