Re: URGENT: SDK ODBC errors

TJ I use MSAccess 2000 linked to Informix 9.21 using ODBC (System DSN, Informix 3.34 32 Bit) on Win NT 4.00.1381. I sometimes get ODBC errors but this is often when the Informix table schema has changed and I have not refreshed the table links. I have also just checked sorting (Using A-Z) on non-indexed columns and it is fine. I hope this provides some help. Kind Regards Ian Logan "The Joker" <monsieur_argent@hotmail.com> wrote in message news:bbidt2$1up$1@terabinaries.xmission.com... > > 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 >