Re: Problem with ODBC and Access

'hner Mike wrote: > > 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. Yes. Informix, true to SQL standards, requires that the order by columns are in the select list. The gist of -309 is that you have tried to order by a column not selected. This is legal in Access and MS SQL and the Sybase engine from which they took their SQL parser, but not in Informix. Art S. Kagel