odbc driver error

I have a microsoft access database that I've linked table to in my informix 7.24 database. I'm using the Informix CLI-2.5 odbc driver. I keep getting the following error -309 __________________________________________________________ ORDER BY column column-name must be in SELECT list. The indicated column appears in the ORDER BY clause of this SELECT, but it is not in the select list (the list of values that follows the word SELECT). This action is not supported. All sort keys must be present in the output rows in order to sort. Revise the statement to follow this rule. If you want to sort only on an expression that involves this column, not on the column itself, refer to the expression by the number of its position in the select list. I am using the following select statement inmy query Select informix_cust.cust_nm from informix_cust order by informix_cust.cust_nm ANy idea why this is happening. I can use dbaccess and run this query just fine. It only errors up when I use the odbc driver through accesss. Thanks Jody -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own