Re: URGENT: SDK ODBC errors
I have a solution. It is a JET engine/ODBC c r a p feature (not sure which), where the query cannot be converted correctly to Informix SQL. The columns are in the select list which is why I was so confused. I got the answer from Impy who sent me a post from a reply to a MS 97 query where sorting on non-index fields was causing this error. The answer, well a work round, is to make the query a snapshot and not dynaset recordset. I haven't got time to really fume and start ripping peoples heads off but I will not forget! Bummer! [Throw away M$Access .... ;-)] TJ >From: Guillermo G'mez Valc'rcel <guillermo.gomez@grafia.es> >To: "The Joker" <monsieur_argent@hotmail.com> >CC: <informix-list@iiug.org> >Subject: Re: URGENT: SDK ODBC errors >Date: Tue, 3 Jun 2003 17:54:37 +0200 > >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 > > > _________________________________________________________________ Tired of 56k? Get a FREE BT Broadband connection http://www.msn.co.uk/specials/btbroadband
"The Joker" <monsieur_argent@hotmail.com> wrote in message news:bbiktu$3cf$1@terabinaries.xmission.com... > > I have a solution. It is a JET engine/ODBC c r a p feature (not sure which), > where the query cannot be converted correctly to Informix SQL. The columns > are in the select list which is why I was so confused. > > I got the answer from Impy who sent me a post from a reply to a MS 97 query > where sorting on non-index fields was causing this error. > > The answer, well a work round, is to make the query a snapshot and not > dynaset recordset. I haven't got time to really fume and start ripping > peoples heads off but I will not forget! > > Bummer! [Throw away M$Access .... ;-)] Frankly, I think it would be more productive to throw away M$ period.