Re: Access97 problems with Informix Online 7.12 and I-CLI 2.5

I am not sure if you have received an answer to your questions yet. Part of our application uses Access. I have run into some of the same things. > I'm using Access as frontend for informix online.Now, I have some > questions: I have Access 97, Informix Online 7.12 and I-CLI 2.5. I can > connect to my informix tables but have some strange problems. > > a.) The informix datatypes are different from the access ones: > > - SERIAL becomes an Access NUMBER This is correct. Access does not have a "serial" type. > - DECIMAL becomes a Text string This is not correct. It should become Number(Double) I am not sure of your problem here. > b.) When I try to change the sort order I get an error -309 from my odbc > driver (I-CLI, Intersolv). The Group By field should also be in the SELECT > statement. But changing the sort order of an indexed field works correct. > You cannot order by any column other than the one that has the index on it. Why? Because Access uses something called the Jet engine. There is one way around it and that is to make your access to the table read only. > Why can't I change the sort order of an unindexed field? Well, its a long story. But to make a long story short its because Microsoft Databases can order by columns not in the Select and an Informix Database can't. If you want more information on this feel free to email me. To email me you must remove "nospam." from my email address. Heather