Re: URGENT: SDK ODBC errors

Are there your order columns in the SELECT list? -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. ----- Original Message ----- From: "The Joker" <monsieur_argent@hotmail.com> To: <informix-list@iiug.org> Sent: Tuesday, June 03, 2003 4:58 PM Subject: URGENT: SDK ODBC errors > Have any of you accessed data through ODBC into a MSAccess DB, linked > Informix tables. We have a Sun Box (5.8) with Informix Dynamic Server > Version 7.31.FD1A. > > I can link tables in M$Access to the Informix source but as soon as you try > and sort by a non-indexed column you get an ODBC error #309, [what!!!!!]. I > have tried SDK versions 3.33 32 bit and 3.80 32bit running on a NT > 4.00.1381. I am running on a very tight schedule and MUST get this working. > You don't need to ask how we got into this position but unless I can find a > solution to the problem, this could be the last post I make! :-( > > Am I using an old version of SDK? Are there some imcompatibility problems > with Jet and Informix SDK ODBC drivers? Help!!! ;-( Or is this just another > MS c o c k up? > > TJ > > _________________________________________________________________ > It's fast, it's easy and it's free. Get MSN Messenger today! > http://www.msn.co.uk/messenger >